ALTER USER { user { IDENTIFIED { BY 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 | 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 } ;
For information on the symbols and conventions of Backus-Naur Form (BNF) syntax, see Appendix A.