Udostępnij za pośrednictwem


DROP LOGIN (Transact-SQL)

Removes a SQL Server login account.

Ikona łącza do tematu Transact-SQL Syntax Conventions

Składnia

DROP LOGIN login_name

Arguments

  • login_name
    Specifies the name of the login to be dropped.

Uwagi

A login cannot be dropped while it is logged in. A login that owns any securable, server-level object, or SQL Server Agent job cannot be dropped.

You can drop a login to which database users are mapped; however, this will create orphaned users. For more information, see Troubleshoot Orphaned Users (SQL Server).

Permissions

Requires ALTER ANY LOGIN permission on the server.

Examples

The following example drops the login WilliJo.

DROP LOGIN WilliJo;
GO  

Zobacz także

Odwołanie

CREATE LOGIN (Transact-SQL)

ALTER LOGIN (Transact-SQL)

EVENTDATA (Transact-SQL)