create login profile

Creates a login profile with specified attributes.

Syntax

create login profile login_profile_name [ as default ] 
	[ with { attributes from login_name | attribute_value_pair_list } ]

Parameters

Examples

Usage

Precedence rules determine how login account attributes are applied when attributes are taken from different login profiles, or when values have been specified using sp_passwordpolicy.

See also:
  • For information about creating login profiles, invoking a login script at login, and precedence rules, see the Security Administration Guide.

  • lprofile_id, lprofile_name in Reference Manual: Building Block

  • sp_passwordpolicy, sp_displaylogin, sp_displayroles, sp_locklogin in Reference Manual: Procedures

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

The permission checks for create login profile differ based on your granular permissions settings.

SettingDescription
Enabled

With granular permissions enabled, you must be a user with the manage any login profile privilege.

Disabled

With granular permissions disabled, you must be a user with sso_role.

Auditing

Values in event and extrainfo columns of sysaudits are:

InformationValues
Event

137

Audit option

security_profile

Command or access audited

create login profile

Information in extrainfo

Keywords contain DEFAULT

If the login profile is made the default: {attributes from login_name | attribute_value_pair_list}

Related reference
alter login
alter login profile
create login
drop login
drop login profile