sp_dropexternlogin

Description

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

Syntax

sp_dropexternlogin remote_server [, login_name] [, role_name]

Parameters

remote_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.

login_name

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

role_name

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 login_name or a System Administrator can execute sp_dropexternlogin.

See also

System procedures sp_addexternlogin, sp_helpexternlogin, sp_addlogin, sp_droplogin