Online Documentation for SQL Manager for PostgreSQL
Editing Policy Definition
Use the Policies tab of Policy Editor to create/edit a policy and specify its properties.
Enter a name for the new policy, or modify the name of the policy being edited. Policy names are per-table. Therefore, one policy name can be used for many different tables and have a definition for each table which is appropriate to that table.
Select a table to create a policy for.
Select the command to which the policy applies: ALL, SELECT, INSERT, UPDATE, or DELETE.
Move the roles from Available to Selected to which the policy is to be applied.
Use this field to define an SQL conditional expression to be added to queries that refer to the table if row level security is enabled. Rows for which the expression returns true will be visible. Any rows for which the expression returns false or null will not be visible to the user (in a SELECT), and will not be available for modification (in an UPDATE or DELETE).
Use this field to define an SQL conditional expression. It's only available for INSERT and UPDATE commands. Only the rows satisfying the expression will be allowed.
The Description field allows you to view and edit the comment for the policy.
After all properties have been set you can enable or force row level security for the table on the Policies tab using the corresponding options:
Enable row level security
Use this option to apply the policies to the table.
Force row level security
With this option ON, row level security policies will be applied when the user is the table owner. If disabled then row level security will not be applied when the user is the table owner.