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