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:
domain‑name\username username@domain‑name
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.