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';