Online Documentation for SQL Manager for PostgreSQL

Policies


A policy grants the permission to select, insert, update, or delete rows that match the relevant policy expression.

 

Table policies are managed within the Policy tab of Table Editor.

 

Creating Policies

To create a new policy:

  • open the table in Table Editor;
  • proceed to the Policies tab there;
  • right-click the tab area and select the New Policy context menu item, or press the Ins key;
  • define the policy properties using the Policy Editor dialog.

 

Editing Policies

To view an existing policy:

  • open the table in Table Editor;
  • proceed to the Policies tab there;
  • right-click the policy and select the Edit Policy <policy_name> context menu item, or simply double-click the policy;
  • edit the policy properties using the Policy Editor dialog.

 

Dropping Policies

To drop a policy:

  • open the table in Table Editor;
  • proceed to the Policies tab there;
  • right-click the policy and select the Drop Policy <policy_name> context menu item;
  • confirm dropping in the dialog window.