User's Manual

sp_revoke_remote procedure
Purpose To stop a user from being able to receive SQL Remote messages from this
database.
Syntax sp_revoke_remote user_name
Argument Description
user_name The user ID who will no longer be able to receive
SQL Remote messages.
See also “sp_grant_remote procedure” on page 393
Description The sp_revoke_remote procedure removes a user ID from the list of users
receiving messages from the current database.
Example
♦ The following statement revokes remote permissions from user Field
User:
sp_revoke_remote ’Field user’
go
432