How to fix the Oracle error ORA-28024: must revoke grants of external roles to this role/user?

In this post, you’ll learn more about the Oracle ErrorORA-28024: must revoke grants of external roles to this role/user with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-28024: must revoke grants of external roles to this role/user

Reason for the Error ORA-28024: must revoke grants of external roles to this role/user

The user or role altered to IDENTIFIED GLOBALLY has external roles directly granted – these must be revoked, since external roles cannot be granted to global users or roles.

How to fix the Error ORA-28024: must revoke grants of external roles to this role/user ?

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

Use REVOKE to revoke the external roles from the user or role to be ALTERed.