REVOKE REMOTE DBA statement [SQL Remote]

This statement revokes REMOTE DBA authority from a user ID.

Syntax 1
REVOKE REMOTE DBA
FROM userid, ...
Remarks

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.

Permissions

Must have DBA authority.

Side effects

Automatic commit.

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

Examples

The following statement revokes REMOTE DBA permission from user S_Beaulieu.

REVOKE REMOTE DBA FROM S_Beaulieu;