Name
CREATE USER
Synopsis
CREATE USERusernameIDENTIFIED {BYpassword| EXTERNALLY | GLOBALLY AS 'external_name'} [DEFAULT TABLESPACEtablespace_name] [TEMPORARY TABLESPACEtablespace_name] [QUOTA {integer(K | M) | UNLIMITED} ONtablespace_name] [QUOTA {integer(K | M) | UNLIMITED} ONtablespace_name. . . ] [PROFILEprofilename] [PASSWORD EXPIRE] [ACCOUNT LOCK | UNLOCK]
Creates a user and specifies basic characteristics of the user.
Keywords
- IDENTIFIED BY
Specifies the way the user will be authenticated. There are three options for authentication:
- PASSWORD
Identified with a locally stored password. The password can contain only single-byte characters from the database character set.
- EXTERNALLY
Identified by an external service, such as the operating system. If you want the user to have access only through the operating system account, add the OS_AUTHENT_PREFIX parameter value before the username.
- GLOBALLY AS 'external_name'
Identified by an enterprise directory service. The external_string can be either the Distinguished Name from the directory or NULL, which indicates that the directory will map users to the appropriate database schema.
- DEFAULT TABLESPACE
Specifies the default tablespace for objects created by the user. The default is the SYSTEM tablespace.
- TEMPORARY TABLESPACE
Specifies the tablespace used for the user’s temporary storage. The default is the SYSTEM tablespace.
- QUOTA
Specifies the amount of space the user can use in the specified tablespace. You can have multiple QUOTA clauses ...