Error: ORA-01927: cannot REVOKE privileges you did not grant (Security Manager).

Message

ORA-01927: cannot REVOKE privileges you did not grant

Cause of Error

This behavior occurs when you try to revoke a privilege that you did not grant.

Solution Summary

Find the person who granted the privilege (the grantor), and have the grantor revoke the privilege from the user.

Solution Details

1) Find the user who granted the privilege:
a) Start Oracle SQL*Plus 8.0, and then log on to the appropriate database.
b) At the SQL*Plus prompt, type the following command, and then press ENTER:
SELECT * FROM all_tab_privs;

NOTE: This command may return a long list. To shorten the list, you can add criteria in a WHERE clause. For example, if you know the grantor is not SYS or SYSTEM, you can add the following WHERE clause:
WHERE grantor not in ('SYS', 'SYSTEM').
c) Review the list returned to determine the grantor.
2) Ask the grantor to log on to the appropriate database and revoke the privilege from the user.

NOTE: If the grantor does not have DBA privilege and you want him or her to use Security Manager to revoke the privilege, you must grant the SELECT_CATALOG_ROLE and the SELECT ANY TABLE system privileges to the grantor.

Applies to Software Version

Oracle8 Security Manager