Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » UltraLite - Database Management and Developer Guide » UltraLite SQL reference » UltraLite SQL statements

CREATE USER statement [UltraLite]

Creates a database user or group.

Syntax
CREATE USER user-name IDENTIFIED BY password 
Parameters
  • user-name

    The name of the user you are creating.

  • password

    The password for the user you are creating.

Remarks

If you use this statement in a procedure, do not specify the password as a string literal because the definition of the procedure is visible in the SYSPROCEDURE system view. For security purposes, specify the password using a variable that is declared outside of the procedure definition.

  • User IDs cannot:

    • begin with white space, single quotes, or double quotes
    • end with white space
    • contain semicolons
  • Passwords are case-sensitive and they cannot:

    • begin with white space, single quotes, or double quotes
    • end with white space
    • contain semicolons
    • be longer than 255 bytes in length
Side effects

None.

Example

The following example creates a user named SQLTester with the password welcome.

CREATE USER SQLTester IDENTIFIED BY welcome