sp_helpexternlogin

Description

(Component Integration Services only) Reports information about external login names.

Syntax

sp_helpexternlogin [server[, loginame[, rolename]]]

Parameters

server

is the name of the remote server that has been added to the local server with sp_addserver.

loginame

is a login account on the local server.

rolename

is the Adaptive Server user’s assigned role.

Examples

Example 1

Displays all remote servers, local login names, role names, and external logins:

sp_helpexternlogin

Example 2

Displays local login names, role names, and external logins for the server named SSB:

sp_helpexternlogin SSB

Example 3

Displays remote servers, local login names and external logins for the user named “milo”:

sp_helpexternlogin NULL, milo

Example 4

Displays external logins for remote server SSB where the local user name is “trixi”:

sp_helpexternlogin SSB, trixi

Example 5

Displays external logins for remote server SSB for local users with sa_role:

sp_helpexternlogin SSB, NULL, sa_role

Usage

Permissions

Any user can execute sp_helpexternlogin. Permission checks do not differ based on the granular permissions settings.

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_addlogin, sp_addserver, sp_dropexternlogin, sp_helpserver