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 MobiLink client utility (dbmlsync) requires Remote DBA authority. 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.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|