Contents Index REVOKE REMOTE statement [SQL Remote] ROLLBACK statement

ASA SQL Reference
  SQL Statements

REVOKE REMOTE DBA statement [SQL Remote]


Description 

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

Syntax 1 

REVOKE REMOTE DBA
FROM userid, ...

Usage 

REMOTE DBA authority enables the Message Agent to have full access to the database in order 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 

REVOKE PUBLISH statement [SQL Remote]

REVOKE REMOTE statement [SQL Remote]

GRANT REMOTE DBA statement [SQL Remote]

REVOKE CONSOLIDATE statement [SQL Remote]

The Message Agent and replication security

Standards and compatibility 

Contents Index REVOKE REMOTE statement [SQL Remote] ROLLBACK statement