What is the purpose of a security predicate function in Row-Level Security (RLS)?

• A. It enables type conversions in predicate functions.
• B. It allows users to run ad hoc queries.
• C. It determines whether a row is accessible to a user based on certain conditions.
• D. It requires data encryption for predicate evaluation.

Answer: (C)

Row-Level Security relies on a security predicate to decide which rows a user can access. The predicate, a boolean condition often implemented as a function, is evaluated for each row using information about the current user or session. When a query runs, only rows that satisfy the predicate are visible, effectively enforcing access control policies like “see only your own records” or “see records within your tenant.” It isn’t about type conversions, it isn’t about enabling ad hoc queries, and it isn’t about encrypting data during evaluation.