Drops a login profile or list of login profiles.
drop login profile login_profile_name [, login_profile_name_list] [ with override ]
drop login profile group1_login_profile
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.
drop login profile sa_login_profile with override
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.
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
ANSI SQL – Compliance level: Transact-SQL extension.
The permission checks for drop login profile differ based on your granular permissions settings.
Setting | Description |
---|---|
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. |
Values in event and extrainfo columns of sysaudits are:
Information | Values |
---|---|
Event | 141 |
Audit option | security_profile |
Command or access audited | drop login profile |
Information in extrainfo | Keywords contain: login_profile_name [WITH OVERRIDE] |