Sybase SQL Remote DC38133-01-0902-01 User Manual
Chapter 18. Command Reference for Adaptive Server Enterprise
sp_revoke_consolidate procedure
Purpose
To stop a user from being able to receive SQL Remote messages from this
database.
database.
Syntax
sp_revoke_consolidate user_name
Argument
Description
user_name
The user ID who will no longer be able to act as a
consolidated database.
consolidated database.
See also
Description
The sp_revoke_consolidate procedure removes the consolidated database
user ID from the list of users receiving messages from the current database.
user ID from the list of users receiving messages from the current database.
Example
♦
The following statement revokes consolidated permissions from user
hq_user:
hq_user:
sp_revoke_consolidate hq_user
go
431