Use this statement to provide DBA privileges to a user ID, but only when connected from the Message Agent.
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 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.
Must have DBA authority.
SQL/2003 Vendor extension.
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|