sp_droplogin

Description

Drops an Adaptive Server user login by deleting the user’s entry from master.dbo.syslogins.

Syntax

sp_droplogin loginame

Parameters

loginame

is the name of the user, as listed in master.dbo.syslogins.

Examples

Example 1

Drops the “victoria” login from Adaptive Server:

sp_droplogin victoria

Usage

Permissions

Only a System Security Officer can execute sp_droplogin.

See also

System procedures sp_addlogin, sp_audit, sp_dropuser, sp_locklogin