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 SQL Remote Message Agent should be run using a user ID with this type of authority to ensure that actions can be carried out without creating security loopholes. The MobiLink client utility, dbmlsync, also requires Remote DBA authority.

See also