Use this statement to create a user.

Syntax

CREATE USER user-name [ IDENTIFIED BY password ]
 [ LOGIN POLICY policy-name ]
 [ FORCE PASSWORD CHANGE { ON | OFF } ]

Parameters

Remarks

You do not have to specify a password for the user. A user without a password cannot connect to the database. This is useful if you are creating a group and do not want anyone to connect to the database using the group user ID. A user ID must be a valid identifier.

User IDs and passwords cannot:

• begin with white space, single quotes, or double quotes
• end with white space
• contain semicolons

A password can be either a valid identifier, or a string (maximum 255 bytes) placed in single quotes. Passwords are case sensitive. It is recommended that the password be composed of 7-bit ASCII characters, as other characters may not work correctly if the database server cannot convert them from the client's character set to UTF-8.

Permissions

Must have DBA authority.

Side effects

None.

See also

• CREATE LOGIN POLICY statement
• ALTER LOGIN POLICY statement
• ALTER USER statement
• COMMENT statement
• DROP LOGIN POLICY statement
• DROP USER statement
• Managing login policies overview
• Creating a user and assigning a login policy
• GRANT statement
• min_password_length option [database]

Standards and compatibility

Example

The following example creates a user named SQLTester with the password welcome. The SQLTester user is assigned to the Test1 login policy and the password expires on the next login.

CREATE USER SQLTester IDENTIFIED BY welcome
LOGIN POLICY Test1
FORCE PASSWORD CHANGE ON;

The following example creates a group named MyGroup

CREATE USER MyGroup;
GRANT GROUP TO MyGroup;