sp_dropremotelogin

Description

Drops a remote user login.

Syntax

sp_dropremotelogin remoteserver [, loginame [, remotename] ]

Parameters

remoteserver

is the name of the server that has the remote login to be dropped.

loginame

is the local server’s user name that is associated with the remote server in the sysremotelogins table.

remotename

is the remote user name that gets mapped to loginame when logging in from the remote server.

Examples

Example 1

Drops the entry for the remote server named GATEWAY:

sp_dropremotelogin GATEWAY

Example 2

Drops the entry for mapping remote logins from the remote server GATEWAY to the local user named “churchy”:

sp_dropremotelogin GATEWAY, churchy 

Example 3

Drops the login for the remote user “pogo” on the remote server GATEWAY that was mapped to the local user named “churchy”:

sp_dropremotelogin GATEWAY, churchy, pogo

Usage

Permissions

The permission checks for sp_dropremotelogin differ based on your granular permissions settings.

Granular permissions enabled

With granular permissions enabled, you must be a user with manage any remote login privilege.

Granular permissions disabled

With granular permissions disabled, you must be a user with sa_role.

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_addlogin, sp_addremotelogin, sp_addserver, sp_droplogin, sp_helpremotelogin, sp_helpserver