Oracle7 Server SQL Reference
ALTER ROLE
Purpose
To change the authorization needed to enable a role.
Prerequisites
You must either have been granted the role with the ADMIN OPTION or have ALTER ANY ROLE system privilege.
If you are using Trusted Oracle7 in DBMS MAC mode, your DBMS label must match the role's creation label or you must satisfy one of these criteria:
- If the role's creation label is higher than your DBMS label, you must have READUP and WRITEUP system privileges
- If the role's creation label is lower than your DBMS label, you must have WRITEDOWN system privilege.
- If the role's creation label and your DBMS label are not comparable, you must have READUP, WRITEUP, and WRITEDOWN system privileges.
Syntax
Keywords and Parameters
The keywords and parameters in the ALTER ROLE command all have the same meaning as in the CREATE ROLE command. For information on these keywords and parameters, see the CREATE ROLE command ![[*]](jump.gif)
.
Example
This statement changes the password on the TELLER role to LETTER:
ALTER ROLE teller
IDENTIFIED BY letter
Users granted the TELLER role must subsequently specify the new password to enable the role.
Related Topics
CREATE ROLE command
SET ROLE command