REVOKE REMOTE DBA
FROM userid, ...

In MobiLink, REMOTE DBA authority is a level of permission required by the SQL Anywhere synchronization client (dbmlsync).

In SQL Remote, REMOTE DBA authority enables the SQL Remote Message Agent to have full access to the database to make any changes contained in the messages, while avoiding security problems associated with distributing DBA user IDs passwords.

DBA authority

Automatic commit.

• REVOKE PUBLISH statement [SQL Remote]
• REVOKE REMOTE statement [SQL Remote]
• GRANT REMOTE DBA statement [MobiLink] [SQL Remote]
• REVOKE CONSOLIDATE statement [SQL Remote]
• Initiating synchronization
• Granting REMOTE DBA authority

The following statement revokes REMOTE DBA permission from user S_Beaulieu.

REVOKE REMOTE DBA FROM S_Beaulieu;