Drops an existing Cirro role.

Syntax


DROP ROLE roleName;

Arguments

  • roleName: The name of an existing role.

Additional Information

  • A role must be revoked from all other users and roles before it can be dropped. See REVOKE <role>

  • The SYS.SYSPERMISSIONS table shows granted or revoked user roles and privileges.

Examples


DROP ROLE Ora1_read_write