drop login

Description

Drops a login account or list of accounts.

Syntax

drop login login_name [, login_name_list] [ with override ]

Parameters

login_name

specifies the name of login account to be dropped.

login_name_list

specifies a list of login accounts to be dropped.

with override

drops the login even if there are non-available databases that cannot be checked for login references.

Examples

Example 1

Drops the login accounts ravi and vinod.

drop login ravi, vinod

Usage

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

You must have sso_role privileges to drop login accounts.

Auditing

Values in event and extrainfo columns of sysaudits are:

Event

Audit option

Command or access audited

Information in extrainfo

139

login_admin

drop login

Keywords contain:

loginname1[, ... [, loginnameN ]]

See also

Commands create login profile, create login, drop login profile, alter login, alter login profile,

Documents For more information about dropping login accounts, see the Security Administration Guide.

Functions lprofile_id, lprofile_name

System procedures sp_passwordpolicy, sp_displaylogin, sp_displayroles, sp_locklogin