OCI-01927
A privilege cannot be revoked if you did not grant it.
Cause
An attempt was made to revoke an object privilege or a user privilege that you did not originally grant. You can only revoke privileges that you have granted. Alternatively, ensure that you have the GRANT ANY OBJECT PRIVILEGE system privilege to revoke object privileges or user privileges that have been granted to another user.
Action
Ensure that you are revoking the correct privilege from the correct user or role.
- Review the granted privileges and grantor in the DBA_TAB_PRIVS view.
- Check if the current session has GRANT ANY OBJECT PRIVILEGE by querying the SESSION_PRIVS view.