Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » Context-Sensitive Help » SQL Anywhere plug-in help » SQL Anywhere properties windows

 

Consolidated User Properties window: Authorities tab

This tab applies to version 12.0.1 and earlier databases and 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.

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

  • 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.

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

  • 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.

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

  • 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.