Ensuring resource limits groups security

In order to protect the limits that have been specified for each user, QMF catalog-based resource limits groups are securely stored in the table RDBI.RESOURCE_TABLE that is part of the QMF catalog and resides on a database server.

You must have the authorization to execute the QMF application package on the database server in order to make any changes to a resource limits group. This prevents unauthorized users from changing the resource limits.

A view named RDBI.RESOURCE_VIEW is defined for the resource limits table. QMF applications access the resource limits information using the view so the table remains intact.

Note: The Default resource limits group resource limit information is stored in the repository and not in the RDBI.RESOURCE_TABLE on the database server. That means any user who can access the repository can make changes to the resource limits of the default resource limits group.