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

SQL Anywhere 12.0.0 » SQL Anywhere Server - Database Administration » Configuring your database » Managing user IDs, authorities, and permissions

 

Specifying the permissions required to execute file administration statements

The -gu database server option controls who can execute file administration statements. You can use this option to specify which users are able to execute certain administration tasks. See -gu dbeng12/dbsrv12 server option.

There are four levels of permission for the use of file administration statements:

-gu option Effect Applies to
all Anyone can execute file administration statements Any database including utility database
none No one can execute file administration statements Any database including utility database
DBA Only users with DBA authority can execute file administration statements Any database including utility database
utility_db Only the users who can connect to the utility database can execute file administration statements Only the utility database
 Examples