Question

Which type of security predicate should you use to explicitly block all write operations that violate the predicate in Row-level security (RLS)?

A. Filter Predicate
B. Block Predicate

Answer 1

To block write operations that violate a predicate in Row-level security, a Block Predicate should be used. It prevents undesired insertions, updates, or deletions based on the specified conditions.

Step-by-step explanation:

To explicitly block all write operations that violate the predicate in Row-level security (RLS), you should use a Block Predicate.

A Block Predicate is used in RLS to prevent users from inserting, updating, or deleting rows that do not satisfy the predicate expression. In contrast, a Filter Predicate is used to limit the rows a user can read by applying a filter to each query.