Resources Used by Connections

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, so that one connection does not slow down other users of the database.

• Database Options That Govern User Resources
  Sybase IQ provides a set of database options that the DBA can use to control resources. These options are called resource governors.
• Limits on Database Connections
  You can control resources available to users with Sybase IQ Login Management, which lets you limit the number of connections to a database for all users or for an individual user, set password expirations, and lock out individual users so that they cannot connect to the database.
• Using Procedures to Disable Connections
  To disable connections, use the stored procedure sp_iqmodifylogin.