|Oracle9i SQL Reference
Release 2 (9.2)
Part Number A96540-01
SQL Statements: ALTER CLUSTER to ALTER SEQUENCE, 19 of 21
ROLE statement to change the authorization needed to enable a role.
You must either have been granted the role with the
OPTION or have
ROLE system privilege.
Before you alter a role to
GLOBALLY, you must:
The one exception to this rule is that you should not revoke the role from the user who is currently altering the role.
The keywords and parameters in the
ROLE statement all have the same meaning as in the
CREATE ROLE and the examples that follow
The following statement changes the role
warehouse_user (created in "Creating a Role: Example") to
This statement changes the password on the
dw_manager role (created in "Creating a Role: Example") to
Users granted the
dw_manager role must subsequently enter the new password "data" to enable the role.
The following example changes the
dw_manager role to an application role using the