Chapter 1: System Procedures

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

sp_dropexternlogin drops the definition of a remote login previously defined to the local server by sp_addexternlogin.
You cannot execute sp_dropexternlogin from within a transaction.
The remote server must be defined to the local server by sp_addserver.
To add and drop local server users, use the system procedures sp_addalias and sp_droplogin.

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