Skip to content

How to Resolve ORA-01927: cannot REVOKE privileges you did not grant

  • by

ORA-01927

In the previous post, we have talked about error ORA-01952 when revoking an ungranted system privilege from an user. Similarly, we got error ORA-01927 when revoking an ungranted object privilege from an user.

SQL> revoke select on hr.employees from scott;
revoke select on hr.employees from scott
*
ERROR at line 1:
ORA-01927: cannot REVOKE privileges you did not grant

ORA-01927 means that the object privilege you want to remove from a user has never been granted to it. That's why the statement failed. You can ignore it if you have known the whole truth.

Leave a Reply

Your email address will not be published.