Online Documentation for SQL Manager for PostgreSQL

Managing users


If you are not connected to the database server yet, select the host from the drop-down list on the Navigation bar to define connection settings.

 

User Manager

 

The list displays the existing users as a grid with the following columns: User Name, System ID, Can Login, Superuser, Can Create DB, Can Create Role, Inherit, Connection Limit, Valid Until, Modify Catalog, User Count, Group Count.

 

Click a column caption to sort items by values of this column in the ascending or the descending mode.

 

Right-click an item within the list to call the context menu allowing you to create a new user and specify its properties using Role Editor, edit, rename, delete the selected user, change (reassign) owner of objects (for PostgreSQL 8.2 and higher), show/hide groups, or show/hide columns of the list.

 

Users management tools are also available through the Navigation bar and toolbar of the User Manager.