ALTER USER
{ user
{ IDENTIFIED
{ BY password [ REPLACE old_password ]
| EXTERNALLY [ AS 'certificate_DN' | AS 'kerberos_principal_name' ]
| GLOBALLY [ AS '[directory_DN]' ]
}
| NO AUTHENTICATION
| DEFAULT COLLATION collation_name
| DEFAULT TABLESPACE tablespace
| [ LOCAL ] TEMPORARY TABLESPACE { tablespace | tablespace_group_name }
| { QUOTA { size_clause
| UNLIMITED
} ON tablespace
} ...
| PROFILE profile
| DEFAULT ROLE { role [, role ]...
| ALL [ EXCEPT role [, role ]... ]
| NONE
}
| PASSWORD EXPIRE
| ACCOUNT { LOCK | UNLOCK }
| ENABLE EDITIONS [ FOR object_type [, object_type ]... ] [ FORCE ]
| [HTTP] DIGEST { ENABLE | DISABLE }
| CONTAINER = { CURRENT | ALL }
| container_data_clause
} ...
| user [, user ]... proxy_clause
} ;