User's 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.
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.
See also “sp_grant_consolidate procedure” on page 390
Description The sp_revoke_consolidate procedure removes the consolidated 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:
sp_revoke_consolidate hq_user
go
431