Group Properties window: Authorities tab

This tab has the following components:

  • DBA   Grants DBA authority to the group; a group with DBA authority can fully administer the database.

  • Resource   Grants resource authority to the group; a group with resource authority can create database objects.

  • Remote DBA   Grants Remote DBA authority to the group. The MobiLink client utility (dbmlsync) requires REMOTE DBA authority. A user ID with this type of authority should run the SQL Remote Message Agent (dbremote) to ensure that actions can be performed without creating security loopholes.

  • Backup   Select this option to grant backup authority to the group.

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

  • Profile   Grants application profiling and database tracing capabilities to the group.

  • Read file   Grants the ability to use query files using the OPENSTRING clause of the SELECT statement.

  • Read Client File   Grants the ability to read a file on the client computer.

  • Write Client File   Grants the ability to write to a file on the client computer.

 See also