Drops a remote user login.
sp_dropremotelogin remoteserver [, loginame [, remotename] ]
sp_dropremotelogin GATEWAY
sp_dropremotelogin GATEWAY, churchy
sp_dropremotelogin GATEWAY, churchy, pogo
Executing sp_dropremotelogin drops a user login from a remote server, deleting the user’s entry from master.dbo.sysremotelogins.
For a more complete discussion on remote logins, see sp_addremotelogin.
To add and drop local server users, use the commands create login and drop login.
The permission checks for sp_dropremotelogin 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. |
Disabled | With granular permissions disabled, you must be a user with sa_role. |
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 |
|