Use this statement to grant remote DBA privileges to a user ID.
GRANT REMOTE DBA TO userid, ... IDENTIFIED BY password
This statement grants a limited set of DBA permissions ideal for synchronization users. The remote DBA privilege avoids having to grant full DBA privileges, thereby avoiding security problems associated with distributing DBA user IDs and passwords.
In MobiLink, REMOTE DBA authority is recommended for the SQL Anywhere synchronization client (dbmlsync). See Permissions for 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.
For SQL Remote, the REMOTE DBA privilege has the following properties:
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|