Collection Contents Index How user permissions are assessed Users and permissions in the system tables pdf/chap21.pdf

User's Guide
   PART 4. Database Administration and Advanced Use
     CHAPTER 21. Managing User IDs 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 wish to prevent a single connection from taking too much of the available memory or CPU resources, in order to avoid a connection from slowing down other users of the database.

Adaptive Server Anywhere provides a set of database options that the DBA can use to control resources. These options are called resource governors.

Setting options 

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

SET [ TEMPORARY ] OPTION
... [ userid. | PUBLIC. ]option-name = [ option-value ]

For Info     For reference information about options, see Database Options. For information on the SET OPTION statement, see SET OPTION statement.

Resources that can be managed 

The following options can be used to manage resources:

Database option settings are not inherited through the group structure.


Collection Contents Index How user permissions are assessed Users and permissions in the system tables pdf/chap21.pdf