|Oracle8i SQL Reference
Release 3 (8.1.7)
Part Number A85397-01
DROP SEQUENCE to UPDATE, 23 of 27
ROLE statement to enable and disable roles for your current session.
When a user logs on, Oracle enables all privileges granted explicitly to the user and all privileges in the user's default roles. During the session, the user or an application can use the
ROLE statement any number of times to change the roles currently enabled for the session. The number of roles that can be concurrently enabled is limited by the initialization parameter
You can see which roles are currently enabled by examining the
SESSION_ROLES data dictionary view.
You must already have been granted the roles that you name in the
Specify a role to be enabled for the current session. Any roles not listed are disabled for the current session.
Restriction: You cannot specify a role unless it was granted to you either directly or through other roles.
Specify the password for a role. If the role has a password, you must specify the password to enable the role.
ALL to enable all roles granted to you for the current session except those optionally listed in the
Restriction: You cannot use this clause to enable roles with passwords that have been granted directly to you.
Roles listed in the
If you list a role in the
NONE to disable all roles for the current session, including the
To enable the role
gardener identified by the password
marigolds for your current session, issue the following statement:
To enable all roles granted to you for the current session, issue the following statement:
To enable all roles granted to you except
banker, issue the following statement:
To disable all roles granted to you for the current session, issue the following statement: