drop login profile

Drops a login profile or list of login profiles.

Syntax

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

Parameters

Examples

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 to a login account, the login account is bound to the default login account, if one exist. If the default login profile is also not present, precedence rules prior to SAP ASE version 15.7 are observed for the login account.

See also:
  • For more information about dropping login profiles, see the Security Administration Guide.

  • lprofile_id, lprofile_name in Reference Manual: Building Blocks

  • 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 drop login profile differ based on your granular permissions settings.

SettingDescription
Enabled

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

Disabled

With granular permissions disabled, you must be a user with sso_role to drop the login profile.

Auditing

Values in event and extrainfo columns of sysaudits are:

InformationValues
Event

141

Audit option

security_profile

Command or access audited

drop login profile

Information in extrainfo

Keywords contain: login_profile_name [WITH OVERRIDE]

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