ORA-01981

All posts relating to Oracle database administration.

Moderator: Tim...

ORA-01981

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

Hello,

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.
me_lucky
Senior Member
 
Posts: 168
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,
Lucky
me_lucky
Senior Member
 
Posts: 168
Joined: Tue Jun 02, 2009 11:40 am

Re: ORA-01981

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

Hi.

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...

Cheers

Tim...
Tim...
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: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17935
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 2 guests

cron