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
}
;