(Component Integration Services only) Drops the definition of a remote login previously defined by sp_addexternlogin.
sp_dropexternlogin server [, loginame [, rolename ] ]
sp_dropexternlogin CIS1012, bobj
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 sp_addalias, create login, and drop login.
The permission checks for sp_dropexternlogin differ based on your granular permissions settings.
Setting | Description |
---|---|
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. |
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:
Information | Values |
---|---|
Event | 38 |
Audit option | exec_procedure |
Command or access audited | Execution of a procedure |
Information in extrainfo |
|