ALTER LOGIN
ALTER LOGIN SET
Updates the configuration of the specified login.
For more information, see Managing logins.
Syntax
ALTER LOGIN <login_name> SET
[ IS_PASSWORD_ENABLED = { TRUE | FALSE } ]
[ IS_MFA_ENABLED = { TRUE | FALSE } ]
[ NETWORK_POLICY = <network_policy_name> | DEFAULT ]
[ IS_ORGANIZATION_ADMIN = { TRUE | FALSE } ]
[ IS_ENABLED = { 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. Specifying DEFAULT will detach any linked network policy. |
IS_ORGANIZATION_ADMIN | A BOOLEAN value specifying if the login is an organization admin. By default this value is FALSE . |
IS_ENABLED | A BOOLEAN value specifying whether authentication with this login should be possible. Disable login if you want to prevent access to the system without dropping it. |
<first_name> , <last_name> | The first and last name of the user to use the login. If the parameter is included, these values cannot be empty. |
Example
This command will link the network policy “my_network_policy” to the “alexs@acme.com” login.
ALTER LOGIN "alexs@acme.com" SET NETWORK_POLICY = "my_network_policy";
ALTER LOGIN RENAME TO
Renames a login.
A login that was created using single sign-on (SSO) cannot be renamed.
Syntax
ALTER LOGIN <login_name> RENAME TO <new_login_name>
Parameters
Parameter | Description |
---|---|
<login_name> | The name of the login to rename. |
<new_login_name> | The new name of the login in the form of an email address. The login must be unique within the organization. If the login was created using SSO, it cannot be renamed. |
Example
The following command will rename the “alexs@acme.com” login to “alexspotter@acme.com”.
ALTER LOGIN "alexs@acme.com" RENAME TO "alexspotter@acme.com";
ALTER LOGIN OWNER TO
Changes the owner of a login.
You can view the current owner in the login_owner
column of the information_schema.logins
view.
For more information, see ownership.
Syntax
ALTER LOGIN <login_name> OWNER TO <identity>
Parameters
Parameter | Description |
---|---|
<login_name> | The name of the login to change the owner of. |
<identity> | The new owner of the login, which can be the name of another login or service account. |
Example
The following command will set login “bob@acme.com” owner to “alice@acme.com”.
ALTER LOGIN "bob@acme.com" OWNER TO "alice@acme.com";