Role is not working properly
HG75May 29 2009 — edited May 29 2009Hi Masters,
I have a problem in my DB.
I have XYZ_UPDATE Role with DML Privileges to many tables in schema XYZ. Role created long time ago.
then recently I added table A,B, and C to the schema XYZ and grant DML privileges to those table to Role XYZ_UPDATE.
One Developer, say John, have been granted this role since first time.
John was able to perform DML using SQL command against table A,B,and C. However when John tried to create a procedure INS_A
which has Insert Into XYZ.A, and compile, he got Insufficient Priviledge Error....
This problem is currently solved by Grant INSERT on A to John.
Did I have to change something in my Role so I don't have to Grant permission for single table everytime developer ask.?
thanks