CREATE LOGIN
Creates a new login.
For more information, see Managing logins.
Syntax
CREATE LOGIN [ IF NOT EXISTS ] <login_name>
WITH [ IS_PASSWORD_ENABLED = { TRUE | FALSE }]
[ IS_MFA_ENABLED = { TRUE | FALSE }]
[ NETWORK_POLICY = <network_policy_name>]
[ IS_ORGANIZATION_ADMIN = { TRUE | FALSE }]
FIRST_NAME = <first_name>,
LAST_NAME = <last_name>
Parameters
Parameter | Description |
---|---|
<login_name> | The name of the login in the form of an email address. The login must be unique within the organization. |
IS_PASSWORD_ENABLED | A BOOLEAN value specifying if login with password is enabled. By default this is TRUE and passwords can be used to log in. |
IS_MFA_ENABLED | A BOOLEAN value specifying if the login has multi-factor authentication (MFA) enabled. By default this value is FALSE . If set to TRUE , an enrollment email will be sent to the <login_name> . |
<network_policy_name> | An optional parameter to define the network policy to link to the created login. |
IS_ORGANIZATION_ADMIN | A BOOLEAN value specifying if the login is an organization admin. By default this value is FALSE . |
<first_name> , <last_name> | The first and last name of the user that will use the created login. |
Example
The following command will create an account in the US East (N. Virginia) region.
CREATE LOGIN "alexs@acme.com" WITH FIRST_NAME = 'Alex' LAST_NAME = 'Summers';