CREATE USER statement [UltraLite]

CREATE USER statement [UltraLite]

Creates a database user or group.

Note

This statement is not supported by UltraLite Java edition databases.

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

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

Permissions

Side effects

See also

Standards and compatibility

Example

Discuss this page in DocCommentXchange.

Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1