permission cache entries

permission cache entries determines the number of cache protectors per task, increasing the amount of memory for each user connection and worker process.

Summary Information

Default value

64

Range of values

1–2147483647

Status

Dynamic

Display level

Comprehensive

Required role

System administrator

Configuration groups

Memory Use, User Environment

Information about user permissions is held in the permission cache. When SAP ASE checks permissions, it looks first in the permission cache; if it does not find what it needs, it looks in the sysprotects table. This process is significantly faster if SAP ASE finds the information it needs in the permission cache and does not have to read sysprotects.

However, SAP ASE looks in the permission cache only when it is checking user permissions, not when permissions are being granted or revoked. When a permission is granted or revoked, the entire permission cache is flushed. This is because existing permissions have timestamps that become outdated when new permissions are granted or revoked.

If users on your SAP ASE frequently perform operations that require their permissions to be checked, you may see a small performance gain by increasing the value of permission cache entries. This effect is not likely to be significant enough to warrant extensive tuning.

If users on your SAP ASE frequently grant or revoke permissions, avoid setting permission cache entries to a large value. The space used for the permission cache would be wasted, since the cache is flushed with each grant and revoke command.