Oracle Solution for Error ora-28024

Solution for Oracle Error ORA-28024

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

What triggered the Error:

e 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.

What should we do to fix it:

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