|
|
ALTER USER
Change the properties of a user.
Syntax:
ALTER USER username options ALTER USER username,... {GRANT|REVOKE} proxy_options options: IDENTIFIED {BY password | EXTERNALLY | GLOBALLY AS external_name} DEFAULT TABLESPACE tablespace_name TEMPORARY TABLESPACE tablespace_name QUOTA int {K | M} ON tablespace_name QUOTA UNLIMITED ON tablespace_name PROFILE profile_name DEFAULT ROLE role[role,...] DEFAULT ROLE ALL [EXCEPT role,...] DEFAULT ROLE NONE PASSWORD EXPIRE ACCOUNT {LOCK|UNLOCK} proxy_options: CONNECT THROUGH proxy [WITH ROLE role_name,...] CONNECT THROUGH proxy [WITH ROLE ALL EXCEPT role_name,...] CONNECT THROUGH proxy [WITH NONE]
"When people tell you how young you look, they
are also telling you how old you are" - Cary
Grant
Related Commands:
CREATE USER
DROP USER
ORA-01017 - Invalid Username/Password
Related Views:
USER_PASSWORD_LIMITS SESSION_ROLES SESSION_PRIVS SESSION_CONTEXT DBA_TS_QUOTAS USER_TS_QUOTAS DBA_USERS ALL_USERS USER_USERS V$SESSION V$SESSION_CONNECT_INFO