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

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.

You must have the MANAGE ANY USER system privilege.

None.

• CREATE LOGIN POLICY statement
• ALTER LOGIN POLICY statement
• ALTER USER statement
• COMMENT statement
• DROP LOGIN POLICY statement
• DROP USER statement
• Login policies
• Creating a user (Sybase Central)
• GRANT statement
• min_password_length option

The following example creates a user named SQLTester with the password welcome. The SQLTester user will be required to specify a password when they log in.

CREATE USER SQLTester IDENTIFIED BY welcome
FORCE PASSWORD CHANGE ON;