Oracle8i SQL Reference Release 2 (8.1.6) A76989-01 |
|
SQL Statements (continued), 15 of 17
To change the authorization needed to enable a role. For information on creating a role, see "CREATE ROLE". For information on enabling or disabling a role for your session, see "SET ROLE".
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:
PUBLIC
.
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".
The following statement changes the role ANALYST
to IDENTIFIED
GLOBALLY
:
ALTER ROLE analyst IDENTIFIED GLOBALLY;
This statement changes the password on the TELLER
role to LETTER
:
ALTER ROLE teller IDENTIFIED BY letter;
Users granted the TELLER
role must subsequently enter the new password "letter" to enable the role.
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|