Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
SQL Statements:
ALTER CLUSTER to ALTER SEQUENCE, 16 of 18
Use the ALTER
ROLE
statement to change the authorization needed to enable a 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.
alter_role::=
alter_role
The keywords and parameters in the ALTER
ROLE
statement all have the same meaning as in the CREATE
ROLE
statement.
The following statement changes the role analyst
to IDENTIFIED
GLOBALLY
:
ALTER ROLE app_user 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.
The following example changes the analyze
role to an application role using the hr.admin
package:
ALTER ROLE analyst IDENTIFIED USING hr.admin;
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|