Dropping a Compatibility Role

All compatibility roles, with the exception of SYS_AUTH_SA_ROLE and SYS_AUTH_SSO_ROLE can be dropped. SYS_AUTH_SA_ROLE and SYS_AUTH_SSO_ROLE are automatically dropped when SYS_AUTH_DBA_ROLE is dropped.

Prerequisites

Administrative privilege over the role being dropped.

Task

The WITH REVOKE clause is required only when dropping a compatibility role which is granted to users or roles.

To delete a compatibility role, execute one of the following statements:

Drop Condition	Statement
Compatibility role not currently granted to any user or role.	DROP ROLE `role_name`^†
Compatibility role currently granted to users or roles.	DROP ROLE `role_name`^† WITH REVOKE

^†role_name cannot be SYS_AUTH_SA_ROLE or SYS_AUTH_SSO_ROLE.