I wanted o restrict update permission to column level on my table. So i have revoked update permission and granted update only on particular columns.
But surprisingly i was able to update all the columns of the filed though i restricted to few columns.
After i checked the permissions on the table i found that "REFERENCES" privilege was there.
What is this privilege? what it has to do with update permission?
This table is referencing so many tables as its a core table, i was unable to revoke that permission.
getting error: ORA-01981.
How to work with that.
Pl help me.
What user are you attempting this from? If you are logged in as the table owner, then no restrictions will work as it is your object...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://oracle-base.com
My blog: http://oracle-base.com/blog
Who is online
Users browsing this forum: No registered users and 10 guests