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

SQL Anywhere 11.0.1 » SQL Anywhere Server - Database Administration » Configuring Your Database » Managing user IDs, authorities, and permissions

 

Managing the resources connections use

Building a set of users and groups allows you to manage permissions on a database. Another aspect of database security and management is to limit the resources an individual user can use.

For example, you may want to prevent a single connection from taking too much of the available memory or CPU resources, so you can avoid having a connection slow down other users of the database.

SQL Anywhere provides a set of database options that users with DBA authority can use to control resources. These options are called resource governors.

Setting options

You can set database options using the SET OPTION statement, with the following syntax:

SET [ TEMPORARY ] OPTION ... [ userid. | PUBLIC. ]option-name = [ option-value ]
Resources that can be managed

You can use the following options to manage resources:

Database option settings are not inherited through the group structure.

See also