OCI-52536
As DATA ROLE role_name has not been granted to grantee_name, it cannot be revoked.
- role_name: The name of the data role.
- grantee_name: The name of the grantee.
Cause
An attempt is being made to revoke a data role that has not been assigned to the specified end user, data role, or application identity.
Action
Query the DBA_DATA_ROLE_GRANTS view for existing data role grants. Do not try to revoke a data role from a grantee that is not granted the data role.