Oracle in a Nutshell

Name

ALTER USER

Synopsis

ALTER USER username
 
        [IDENTIFIED {BY password [REPLACE old_password] 
                EXTERNALLY | GLOBALLY AS 'external_name'}]
        [DEFAULT TABLESPACE tablespace_name]
        [TEMPORARY TABLESPACE tablespace_name]
        [QUOTA {integer [K | M] | UNLIMITED} ON tablespace_name]
                [QUOTA {integer [K | M] | UNLIMITED} ON tablespace_name]
        [PROFILE profile_name]
        [DEFAULT ROLE {[role_name[,role_name . . .] |
                ALL {EXCEPT [role_name[, role_name . . .]} | NONE
        [PASSWORD EXPIRE]
        [ACCOUNT LOCK | UNLOCK]
        [username [,username . . .] proxy_clause]

Changes the characteristics of an existing user.

Keywords

Most keywords for the ALTER USER statement have the same meaning as those in the CREATE USER statement. The following keywords apply to only the ALTER USER statement:

REPLACE old_password

If the password complexity verification function is turned on, you must specify your old password when you change it with the ALTER USER command.

DEFAULT ROLE

A role is a way to manage groups of user privileges for groups of users. You can specify multiple roles for a user, ALL or ALL EXCEPT roles for a user, or no role for a user. For more information on roles, see the later “Roles” section.

proxy_clause

The proxy clause can be used with more than one user’s name. This was new in Oracle8i. In Oracle8i, a user could be identified by a proxy, but the proxy would pass the password to the database for re-authentication. With Oracle9i, the user identity, in the form of a Distinguished Name or a full X.509 certificate, can be passed ...