Sybase SQL Remote DC38133-01-0902-01 User Manual
sp_revoke_remote procedure
Purpose
To stop a user from being able to receive SQL Remote messages from this
database.
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.
SQL Remote messages.
See also
Description
The sp_revoke_remote procedure removes a user ID from the list of users
receiving messages from the current database.
receiving messages from the current database.
Example
♦
The following statement revokes remote permissions from user Field
User:
User:
sp_revoke_remote ’Field user’
go
432