Consolidated User Properties window: Authorities tab

This tab has the following components:

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

  • Resource   Select this option to grant RESOURCE authority to the user; a user with RESOURCE authority can create database objects. See RESOURCE authority.

  • Remote DBA   Select this option to grant Remote DBA authority to the user. The SQL Remote Message Agent (dbremote) should also be run using a user ID with Remote DBA authority to ensure that actions can be performed without creating security loopholes. See GRANT REMOTE DBA statement [MobiLink] [SQL Remote].

  • Backup   Select this option to grant backup authority to the user. See BACKUP authority.

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

  • Profile   Grants application profiling and database tracing capabilities to the user. See PROFILE authority.

  • Readfile   Grants the ability to use query files using the OPENSTRING clause of the SELECT statement. See READFILE authority.

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

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