Name
CREATE USER
Synopsis
CREATE USERusername
IDENTIFIED {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 ...
Get Oracle in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.