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

ParameterDescription
<login_name>The name of the login in the form of an email address. The login must be unique within the organization.
IS_PASSWORD_ENABLEDA BOOLEAN value specifying if login with password is enabled. By default this is TRUE and passwords can be used to log in.
IS_MFA_ENABLEDA 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_ADMINA 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';