|Oracle8i SQL Reference
Release 3 (8.1.7)
Part Number A85397-01
ALTER CLUSTER to ALTER SYSTEM, 15 of 19
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
Note: If you have the
See Also: CREATE ROLE
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.