DROP ROLE

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 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


© Copyright SS64.com 1999-2014
Some rights reserved