Resource Limit Precedence

SAP ASE provides precedence rules for time ranges and resource limits.

For each login session during the currently active time ranges, only one limit can be active for each distinct combination of limit type, enforcement time, and scope.

The precedence rules for determining the active limit are as follows:

Since either the user’s login name or the application name, or both, are used to identify a resource limit, SAP ASE observes a predefined search precedence while scanning the sysresourcelimits table for applicable limits for a login session.

The precedence of matching ordered pairs of login name and application name is:

Level

Login name

Application name

1

joe_user

payroll

2

NULL

payroll

3

joe_user

NULL

If one or more matches are found for a given precedence level, no further levels are searched. This prevents conflicts regarding similar limits for different login/application combinations.

If no match is found at any level, no limit is imposed on the session.