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

 

Publisher 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 publisher; a user with DBA authority can fully administer the database.

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

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

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

  • Validate   Select this option to grant validate authority to the publisher; 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.