All posts relating to Oracle database administration.

Moderator: Tim...

Senior Member
Posts: 183
Joined: Tue Jun 02, 2009 11:40 am


Postby me_lucky » Fri Jan 31, 2014 10:13 am


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.

Senior Member
Posts: 183
Joined: Tue Jun 02, 2009 11:40 am

Re: ORA-01981

Postby me_lucky » Thu Feb 06, 2014 8:08 am

Can any one help me with the answer plz..

Thanks & Regards,

Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: ORA-01981

Postby Tim... » Fri Feb 07, 2014 9:13 am


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
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: https://oracle-base.com
My blog: https://oracle-base.com/blog

Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 1 guest