CREATE USER user
{ {
IDENTIFIED
{
BY password [ [HTTP] DIGEST { ENABLE | DISABLE } ]
| 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
| PASSWORD EXPIRE
| ACCOUNT { LOCK | UNLOCK }
[ DEFAULT TABLESPACE tablespace
| TEMPORARY TABLESPACE
{ tablespace | tablespace_group_name }
| { QUOTA { size_clause | UNLIMITED } ON tablespace }...
| PROFILE profile
| PASSWORD EXPIRE
| ACCOUNT { LOCK | UNLOCK }
| ENABLE EDITIONS
| CONTAINER = { CURRENT | ALL }
]...
] ;