I have setup Oracle 12c RAC with pluggable database and I am try to revoke privileges from DBA on DBA_XS_SESSION_ROLES table by using this command
REVOKE ALL ON SYS.DBA_XS_SESSION_ROLES FROM DBA;
Revoke succeeded.
it shows me revoke succeeded but it is not revoked yet. I am running this as sys user. How to troubleshoot the error ?
I use this command to verify privilege is revoked or not.
SELECT * FROM DBA_TAB_PRIVS WHERE TABLE_NAME LIKE 'DBA_%'