Consolidated User property sheet: Authorities tab

The Authorities tab of the Consolidated User property sheet has the following components:

DBA Select this option to grant DBA authority to the consolidated user; a user with DBA authority can fully administer the database.

Resource Select this option to grant resource authority to the consolidated user; a user with resource authority can create database objects.

Remote DBA Select this option to grant Remote DBA authority to the consolidated user. The MobiLink client utility, dbmlsync, requires Remote DBA authority. The SQL Remote Message Agent should also be run using a user ID with Remote DBA authority to ensure that actions can be performed without creating security loopholes.

Backup Select this option to grant backup authority to the consolidated user.

Validate Select this option to grant validate authority to the consolidated user; a user with validate authority can perform the operations executed by the different VALIDATE statements, such as database, table, index, and checksum validation.