(Component Integration Services only) Reports information about external login names.
sp_helpexternlogin [server[, loginame[, rolename]]]
is the name of the remote server that has been added to the local server with sp_addserver.
is a login account on the local server.
is the Adaptive Server user’s assigned role.
Displays all remote servers, local login names, role names, and external logins:
sp_helpexternlogin
Displays local login names, role names, and external logins for the server named SSB:
sp_helpexternlogin SSB
Displays remote servers, local login names and external logins for the user named “milo”:
sp_helpexternlogin NULL, milo
Displays external logins for remote server SSB where the local user name is “trixi”:
sp_helpexternlogin SSB, trixi
Displays external logins for remote server SSB for local users with sa_role:
sp_helpexternlogin SSB, NULL, sa_role
sp_helpexternlogin displays all remote servers, the user’s local login name, role name, and the user’s external login name.
Add remote servers with sp_addserver. Add local logins with sp_addlogin.
Any user can execute sp_helpexternlogin. Permission checks do not differ based on the granular permissions settings.
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 |
|
System procedures sp_addexternlogin, sp_addlogin, sp_addserver, sp_dropexternlogin, sp_helpserver
