RE: ORA-01927: cannot REVOKE privileges you did not grant

It means you didn't grant it to that user. Looking into the field of GRANTOR in following views:

dba_sys_privs for system privileges
dba_tab_privs for object privileges
dba_role_privs for role privileges

Yanhua Wu
Donaldson Company
612-887-3458
...We become what we practice most...

> -----Original Message-----
> From: John Dunn [SMTP:john.dunn_at_sefas.co.uk]
> Sent: Friday, July 14, 2000 5:36 AM
> To: Multiple recipients of list ORACLE-L
> Subject: ORA-01927: cannot REVOKE privileges you did not grant
>
> Does this mean that the privilege has not been granted, or just that it
> was
> not granted by the user trying to revoke it. How can I find out if a
> privilege has been granted and by what user?
>
> John
>
> --
> Author: John Dunn
> INET: john.dunn_at_sefas.co.uk
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Fri Jul 14 2000 - 10:00:16 CDT