Oracle Error ORA-28404: role cannot be altered

Oracle Error Message

ORA-28404: role cannot be altered

Reason for the Error

An attempt was made to alter the role to become a global, external, password protected, or secure application role. The role could not be altered because it was already granted to one or more other roles.

Solution

Use REVOKE to revoke the role from other roles first.