drop login profile

Description

Drops a login profile or list of login profiles.

Syntax

drop login profile login_profile_name [, login_profile_name_list]
	 [ with override ] 

Parameters

Examples

Example 1

Drops the login profile group1_login_profile if it is not bound to one or more login accounts.

drop login profile group1_login_profile

Example 2

An error is generated because the sa_login_profile being bound to one or more login accounts.

drop login profile sa_login_profile

Msg 11193, Level 16, State 1:
Line 1:
The specified login profile is the default login profile
and/or associated with one or more login accounts. 
Remove the default property and/or associations or use 
the WITH OVERRIDE clause to drop the login profile.

Example 3

The sa_login_profile is dropped even though it is bound to one or more login accounts.

drop login profile sa_login_profile with override

Usage

• The command drop login profile removes the login profile if it is not bound to a login account.

• Use drop login profile with override to forcefully remove a login profile that is bound to a login account. If the login profile is bound with to a login account, the login account will be bound to the default login account, if one exist. If the default login profile is also not present, precedence rules prior to Adaptive Server version 15.7 are observed for the login account.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

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

Auditing

Values in event and extrainfo columns of sysaudits are:

See also