(Component Integration Services only) Drops the definition of a remote login previously defined by .sp_addexternlogin
sp_dropexternlogin server [, loginame [, rolename ] ]
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.
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.
is the Adaptive Server user’s assigned role.
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
Drops the definition of an external login to the remote server SSB from users with the sa_role:
sp_dropexternlogin SSB, NULL, sa_role
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.
The permission checks for sp_dropexternlogin 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. sp_dropexternlogin can be executed by users bound to loginname. |
Granular permissions disabled |
With granular permissions disabled, you must be a user with sa_role. sp_dropexternlogin can be executed by users bound to loginname. |
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_helpexternlogin, sp_addlogin, sp_droplogin
