How to fix the Oracle error ORA-28021: cannot grant global roles?

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

Oracle Error Description

ORA-28021: cannot grant global roles

Reason for the Error ORA-28021: cannot grant global roles

The role granted was IDENTIFIED GLOBALLY. Global roles can only be granted via a central authority for the domain.

How to fix the Error ORA-28021: cannot grant global roles ?

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

Use ALTER ROLE to change the type of role (from IDENTIFIED GLOBALLY to other, such as IDENTIFIED BY password), or allocate it to a global user via the central authority.