Data Replication with SQL Remote
PART 4. Reference
CHAPTER 17. Command Reference for Adaptive Server Anywhere
To provide DBA privileges to a user ID, but only when connected from the Message Agent.
REVOKE REMOTE DBA
FROM userid,...
Must have DBA authority.
Automatic commit.
The Message Agent and replication security
REMOTE DBA authority enables the Message Agent to have full access to the database in order to make any changes contained in the messages, while avoiding security problems associated with distributing DBA user IDs passwords.
This statement revokes REMOTE DBA authority from a user ID.