SQL Remote User's Guide
Command Reference for Adaptive Server Enterprise
To stop a user from being able to receive SQL Remote messages from this database.
sp_revoke_consolidate user_name
| Argument | Description |
|---|---|
| user_name | The user ID who will no longer be able to act as a consolidated database. |
sp_grant_consolidate procedure
The sp_revoke_consolidate procedure removes the consolidated database user ID from the list of users receiving messages from the current database.
The following statement revokes consolidated permissions from user hq_user:
sp_revoke_consolidate hq_user go