CREATE USER Statement

Creates a user.

Syntax

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

Examples

Example 1 – Create 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;
```

Example 2 – Create a group named MyGroup:

CREATE USER MyGroup;
GRANT GROUP TO MyGroup;

Usage

user-name—Name of the user.

IDENTIFIED BY clause—Provides the password for the user.

policy-name—Name of the login policy to assign the user. No change is made if LOGIN POLICY is not specified.

FORCE PASSWORD CHANGE clause—Controls whether the user must specify a new password when they log in. This setting overrides the PASSWORD_EXPIRY_ON_NEXT_LOGIN option setting in their policy.

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. Sybase recommends 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.

The VERIFY_PASSWORD_FUNCTION option can be used to specify a function to implement password rules (for example, passwords must include at least one digit). If a password verification function is used, you cannot specify more than one user ID and password in the GRANT CONNECT statement. For details, see VERIFY_PASSWORD_FUNCTION Option and GRANT Statement.

Note: This reference points to SQL Anywhere documentation.

Standards

SQL—Vendor extension to ISO/ANSI SQL grammar.
Sybase—Not supported by Adaptive Server Enterprise.

Permissions

Requires DBA or USER ADMIN authority.