CREATE USER rene IDENTIFIED BY theSecretPassword …; CREATE USER rene IDENTIFIED BY theSecretPassword [HTTP] DIGEST [ENABLE|DISABLE] …; CREATE USER rene IDENTIFIED EXTERNALLY …; CREATE USER rene IDENTIFIED EXTERNALLY AS 'certificate_DN' …; CREATE USER rene IDENTIFIED EXTERNALLY AS 'kerberos-principal-name' …; CREATE USER rene IDENTIFIED GLOBALLY …; CREATE USER rene IDENTIFIED GLOBALLY AS 'directory_DN' …; CREATE USER rene NO AUTHENTICATION …;
… [ DEFAULT COLLATION … ] [ DEFAULT TABLESPACE … ] [ [LOCAL] TEMPORARY TABLESPACE … ] [ QUOTA [ size-clause | UNLIMITED] ON tablespace ] [ PROFILE … ] [ PASSWORD EXPIRE ] [ ACCOUNT [ LOCK | UNLOCK ] ] [ ENABLE EDITIONS ] [ CONTAINER = [ CURRENT | ALL ]
create user fred identified globally as 'CN=…, OU=sales, O=Acme, C=CH' …;
create user joy identified externally …;