Online Documentation for SQL Manager for PostgreSQL


The Permissions section of the Database Properties dialog allows you to view and set grants for the current database.


Right-click on the grid cell where the row stands for a group or user, and the column is the operation for granting (OWN, CRT, etc), then select the Grant item from the context menu to permit the selected operation to the group/user. See Managing privileges for details.



Allows to set the new owner of the database (to alter the owner, you must own the database and also be a direct or indirect member of the new owning role).



Allows the user to connect to the current database (note that this column appears only when working with server version 8.2 or higher).



Allows new schemas to be created within the database.



Allows temporary tables to be created while using the database.


Database Properties - Permissions