Usage Control

For anonymous or authenticated remote access, particularly across administrative domains, it is essential to control what a database user is allowed to do. Since SQL queries can easily be written to hog resources on the server among other things, there is a need to limit the resources used by any given remote user.

DataCaster supports multiple types of resource usage control for both local and remote users, including anonymous users. Four kinds of usage control are provided:

• Number of Transactions per day
• Index pages read per hour
• Tuples processed per minute.
• Data transferred in bytes/sec.

Using these attributes, usage can be controlled for any user as required, to minimze the damage from intentional or inadvertent excess resource consuption by local or remote users.

Please see the configuraton reference for more information on setting these parameters.