Online Documentation for SQL Manager for PostgreSQL

Granting permissions


Grant user permissions:

To check the rights already granted on specific object, or to grant new rights on it:

Open the object in the respective editor, then switch to the Permissions tab and define user permissions for the object.

 

Grant and edit user rights

Select the Tools | btnGrantManager Grant Manager item of the main menu, then pick the needed object in the Object name column (the easiest way to select an object is to use the drop-down list, which is located above the column)o. Select the user from respective drop-down list on the toolbar and define required user privileges on the object in the appropriate cell.

Note: Cells with actions which cannot be granted on the selected object are highlighted with grey.

 

Grant Manager window contains table, where rows are database object and columns are actions performed under objects.

To grant permissions on object select host, database and user by means of navigation bar and toolbar.

Permission on performing an action can be changed in three ways:

  • use cell context menu;
  • double-click a cell (after each value changing you will be asked to commit operation; note that value will be changed in the following order iconGrantManager_Grant Grant->iconGrantManager_GrantWithGrantOption Grant with GRANT OPTION->iconGrantManager_Revoke Revoke);
  • single-click active cell. This opens drop-down list with all available values.