sp_dropexternlogin

Description

(Component Integration Services only) Drops the definition of a remote login previously defined by .sp_addexternlogin

Syntax

sp_dropexternlogin  server  [,  loginame  [,  rolename ] ]

Parameters

server

is the name of the remote server from which the local server is dropping account access. The remote server is known to the local server by an entry in the master.dbo.sysservers table.

loginame

is a login account known to the local server. If loginame is not specified, the current account is used. loginame must exist in the master.dbo.syslogins table.

rolename

is the Adaptive Server user’s assigned role.

Examples

Example 1

Drops the definition of an external login to the remote server CIS1012 from “bobj”. Only the “bobj” account and the “sa” account can add or modify a remote login for “bobj”:

sp_dropexternlogin CIS1012, bobj

Example 2

Drops the definition of an external login to the remote server SSB from users with the sa_role:

sp_dropexternlogin SSB, NULL, sa_role

Usage

Permissions

Only loginame or a system administrator can execute sp_dropexternlogin.

Auditing

Values in event and extrainfo columns from the sysaudits table are:

Event

Audit option

Command or access audited

Information in extrainfo

38

exec_procedure

Execution of a procedure

  • Roles – Current active roles

  • Keywords or options – NULL

  • Previous value – NULL

  • Current value – NULL

  • Other information – All input parameters

  • Proxy information – Original login name, if set proxy in effect

See also

System procedures sp_addexternlogin, sp_helpexternlogin, sp_addlogin, sp_droplogin