Database Error Messages

ORA-01951

Role "role_name" not granted to "user_name".
  • role_name: The role name being revoked.
  • user_name: The user name from whom the role is being revoked.

Cause

An attempt was made to revoke a role that was not granted to the user.


Action

Query roles granted to the user by issuing the SELECT * FROM DBA_ROLE_PRIVS WHERE GRANTEE = 'USER'; statement. Do not try to revoke a role that is not granted to the user.