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:

If no limit is defined for the login ID for either the “at all times” range or the currently active time ranges, there is no active limit.
If limits are defined for the login for both the “at all times” and time-specific ranges, the limit for the time-specific range takes precedence.

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.