To configure Adaptive Server to use predicated privileges:
Enable the ASE_SECDIR license, required for Adaptive Server Security and Directory Services.. See the Sybase Software Asset Management Users Guide.
Configure the enable predicated privileges configuration parameter. (see below)
Set the value for permission cache entries. Granting access to a single table restricted by multiple predicated privileges increases the number of protection cache entries Adaptive Server requires. Allow one extra protection cache entry for any access that requires more than one predicate evaluation.
Consider whether to increase the size of the procedure cache. If users executing a stored procedure each have different predicated access to the tables referenced by the procedure, Adaptive Server creates a separate plan for each user executing the procedure. In this case, you may need to increase the size of the procedure cache.
