GRANT REMOTE DBA
TO userid, ...
[IDENTIFIED BY password ]

A user ID with REMOTE DBA authority has full DBA authority only:

The REMOTE DBA authority avoids having to grant full DBA authority to the user ID, thereby avoiding security problems associated with distributing DBA user IDs and passwords.

For example, a SQL Remote user ID with REMOTE DBA authority has no extra permissions on any connection apart from the Message Agent. Even if the user ID and password for a REMOTE DBA user is widely distributed, there is no security problem. As long as the user ID has no permissions beyond CONNECT granted on the database, no one can use this user ID to access data in the database.

Must have DBA authority.

Automatic commit.

• MobiLink: Initiating synchronization
• SQL Remote: Granting REMOTE DBA authority
• REVOKE REMOTE DBA statement [SQL Remote]

You can grant REMOTE DBA authority to a user ID named dbremote as follows:

GRANT REMOTE DBA
TO dbremote
IDENTIFIED BY dbremote;