Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

DIA-28024

Cannot alter database user or role that has external roles granted to the user or role.

Cause

The user or role had external roles granted to the user or role. A database user or role that is being altered (ALTER USER or ALTER ROLE) with IDENTIFIED GLOBALLY must not have external roles directly granted to it. These external roles must first be revoked since external roles cannot be granted to global users or roles.


Action

Use REVOKE to revoke the external roles from the database user or role to be altered. Query DBA_ROLE_PRIVS to find the external roles of the users and roles. Query DBA_ROLES with AUTHENTICATION_TYPE=EXTERNAL to identify external roles.