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.
