|Oracle8i SQL Reference
Release 2 (8.1.6)
SQL Statements (continued), 15 of 17
You must either have been granted the role with the
ADMIN OPTION or have
ALTER ANY ROLE system privilege.
Before you alter a role to
IDENTIFIED 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
ALTER ROLE statement all have the same meaning as in the
CREATE ROLE statement. See "CREATE ROLE".
If you have 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.