solidDB Help : solidDB reference : SQL: Statements : CREATE USER
  
CREATE USER
CREATE USER user‑name IDENTIFIED {BY password | EXTERNALLY}
Access requirements
Administrator privileges
Usage
Use the CREATE USER statement to create a new user with a given password.
Parameters, clauses, keywords, and variables
IDENTIFIED BY: Defines that the user is authenticated internally and specifies the user password.
EXTERNALLY: Identifies that the user is authenticated by services provided by the operating system. When using external authentication, the user name must match the user name of an operating system user account.
Note When using external authentication on Windows systems, your environment might require you to provide the user name in the two-part format of domain‑name\username or username@domain‑name. You can specify the domain‑name by using the General.DefaultDomainName parameter. The solidDB server uses the value of the General.DefaultDomainName parameter to resolve the two-part user ID as expected by the Windows operating system.
Alternatively, you can leave the General.DefaultDomainName parameter empty (default) and provide the domain name as part of the user ID of each externally authenticated user.
When you specify the domain name as part of the user name, the following formats are supported:
domainname\username
username@domainname
Because these strings contain either the \ or @ character, the string must be surrounded by double quotation marks. For example:
CREATE USER "chicago_prod\solid1" IDENTIFIED EXTERNALLY
CREATE USER "solid1@chicago_prod" IDENTIFIED EXTERNALLY
Examples
The following example creates a new, internally authenticated user named HOBBES with the password CALVIN.
CREATE USER HOBBES IDENTIFIED BY CALVIN;
The following example creates a new, externally authenticated user named solid1.
CREATE USER solid1 IDENTIFIED EXTERNALLY;
Go up to
SQL: Statements