How to fix the Oracle error ORA-28404: role cannot be altered?

In this post, you’ll learn more about the Oracle ErrorORA-28404: role cannot be altered with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-28404: role cannot be altered

Reason for the Error ORA-28404: role cannot be altered

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.

How to fix the Error ORA-28404: role cannot be altered ?

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

Use REVOKE to revoke the role from other roles first.