Use these commands for granting and revoking predicated privileges:
grant ... where – grant row-level access control to a group, role, or individual user based on conditions expressed through the where clause.
grant role ... where – grant roles whose activation is conditional on the evaluation of a where clause
revoke ... [with { pred_name | {all |no} predicates}] – revoke predicated privileges.
set show_transformed_sql – displays the full SQL text, including the added predicates for row-level filtering.
See the Reference Manual: Commands.
