OraFAQ Forum: Server Administration » ora-01927 cannot revoke privilege you did not grant

Home » RDBMS Server » Server Administration » ora-01927 cannot revoke privilege you did not grant

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ora-01927 cannot revoke privilege you did not grant [message #154336]

Sat, 07 January 2006 00:39

matrik02
Messages: 64
Registered: November 2005

Member

I got the error message like this in the object privileges.How to grant it?

Report message to a moderator

Re: ora-01927 cannot revoke privilege you did not grant [message #154602 is a reply to message #154336]

Mon, 09 January 2006 12:34

DanielRey
Messages: 11
Registered: January 2006
Location: Mendoza, Argentina

Junior Member

Hello matrik02

In dba_tab_privs you'll see the user whom grant the privilege

SQL> desc dba_tab_privs
Name Null? Type
----------------------------------------- -------- -------------
GRANTEE NOT NULL VARCHAR2(30)
OWNER NOT NULL VARCHAR2(30)
TABLE_NAME NOT NULL VARCHAR2(30)
GRANTOR NOT NULL VARCHAR2(30)
PRIVILEGE NOT NULL VARCHAR2(40)
GRANTABLE VARCHAR2(3)
HIERARCHY VARCHAR2(3)

This user must revoke it.

Regards.
Daniel

[Updated on: Mon, 09 January 2006 12:38]

Report message to a moderator

Previous Topic:	size of schema
Next Topic:	Error in setting Automatic Oracle Export Backup in Cron of Unix

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 15:28:59 CDT 2024