|Oracle9i SQL Reference
Release 1 (9.0.1)
Part Number A90125-01
ALTER CLUSTER to ALTER SEQUENCE, 16 of 18
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
The following statement changes the role
This statement changes the password on the
teller role to
Users granted the
teller role must subsequently enter the new password "letter" to enable the role.
The following example changes the
analyze role to an application role using the