alter login profile

Description

Changes the attributes of a login profile.

Syntax

alter login profile login_profile_name
	{  [as [ not ] default ]
	| [modify attribute_value_pair_list ]
	| [add auto activated roles role_name [, role_name_list ]]
	| [drop auto activated roles { ALL | role_name [, role_name_list ]}]
	| [drop attribute_name_list] }

Parameters

Examples

Example 1

Configures eng_lp as the default login profile. If there is an existing default login profile, its default property is removed.

alter login profile eng_lp as default 

Example 2

Alters the login profile mgr_lp to automatically activate the previously granted program_role, product_role, and admin_role, roles on login if they are not password protected.

alter login profile mgr_lp add auto activated roles program _role, product_role, admin_role

Example 3

Alters the login profile mgr_lp to remove the automatic activation of the previously granted role admin_role on login.

alter login profile mgr_lp drop auto activated roles admin_role

Example 4

Alters the login profile mgr_lp to remove the login script attribute. Once removed, a login account associated with mgr_lp will use the values of a default login script, if one is defined. If one is not defined, the login script attribute be set to the default value, which is no login script with be invoked on login.

alter login profile mgr_lp drop login script 

Usage

• Precedence rules determine how login account attributes will be applied when attributes are taken from different login profiles or when values have been specified using sp_passwordpolicy. For precedence rules, see “Applying login profile and password policy attributes,” in the Security Administration Guide.

• You can specify a login script to be invoked at login. For more information, see “Invoking a login script,” in the Security Administration Guide.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Only a system security officer can execute alter login profile.

Auditing

Values in event and extrainfo columns of sysaudits are:

See also