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

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
  




Back to the Top

Simon Sheppard
SS64.com