Database Error Messages

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

DIA-28021

Global roles cannot be granted to a database user or to another role.

Cause

An attempt was made to grant a role identified as global to a database user or role. A global role can only be granted to an enterprise user if they are assigned to the mapped group or role in the external identity service (such as IAM or OUD).


Action

If you need the global role and need a similar role granted to a database user or role, create another role with the same roles and privileges granted to the global role and grant the new role to the database user or role. If the global role is no longer required to be a global role mapped to an external group or role anymore, then use ALTER ROLE to change the type of the role (from IDENTIFIED GLOBALLY to another role such as IDENTIFIED BY password).