Database Administration (MOSC)

MOSC Banner

ORA-01927: cannot REVOKE privileges you did not grant

edited Jan 4, 2017 1:23AM in Database Administration (MOSC) 10 commentsAnswered

Hi,

I am trying to revoke select grant on single table from a user(RO_APPS) but getting error message. Tried with apps,applsys and sys all are giving same error.

Also this user has "Select any table" grant.

SQL> revoke select on applsys.WF_NOTIFICATION_ATTRIBUTES from ro_apps;

revoke select on applsys.WF_NOTIFICATION_ATTRIBUTES from ro_apps

*

ERROR at line 1:

ORA-01927: cannot REVOKE privileges you did not grant

RO_APPS has below grants:

-- 1 Role for RO_APPS

  GRANT CONNECT TO RO_APPS;

  ALTER USER RO_APPS DEFAULT ROLE ALL;

  -- 1 System Privilege for RO_APPS

  GRANT SELECT ANY TABLE TO RO_APPS;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center