ORA-01927: cannot REVOKE privileges you did not grant
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;