Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from 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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page