Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Reference » Using SQL » SQL statements » SQL statements (P-Z)


REVOKE REMOTE DBA statement [SQL Remote]

Use this statement to provide DBA privileges to a user ID, but only when connected from the Message Agent.

Syntax 1
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.

  • This statement revokes REMOTE DBA authority from a user ID.

Must have DBA authority.

Side effects

Automatic commit.

See also
Standards and compatibility
  • SQL/2003   Vendor extension.