Drop a user role.
Syntax:
DROP ROLE role
When dropping a role, Oracle will automatically revoke all grants of the role from all users (and roles).
User sessions in which the role is already enabled are not affected until they disconnect.
“Small is beautiful” ~ E. F.Schumacher
Related Oracle Commands:
PROFILE - ALTER PROFILE
ROLE - ALTER ROLE
ROLE - SET ROLE
Related Views:
USER_RESOURCE_LIMITS DBA_RGROUP DBA_ROLES DBA_ROLE_PRIVS USER_ROLE_PRIVS ROLE_ROLE_PRIVS DBA_SYS_PRIVS USER_SYS_PRIVS ROLE_SYS_PRIVS