How to fix the Oracle error ORA-28022: cannot grant external roles to global user or role?

In this post, you’ll learn more about the Oracle ErrorORA-28022: cannot grant external roles to global user or role with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-28022: cannot grant external roles to global user or role

Reason for the Error ORA-28022: cannot grant external roles to global user or role

The role granted was IDENTIFIED EXTERNALLY. External roles cannot be granted to global users, to global roles or to any other roles.

How to fix the Error ORA-28022: cannot grant external roles to global user or role ?

You can fix this error in Oracle by following the below steps

Use ALTER ROLE to change the type of the role being granted (from IDENTIFIED EXTERNALLY to other, such as NOT IDENTIFIED) or use ALTER USER to change the type of the user that is the grantee.