Online Documentation for SQL Manager for PostgreSQL
Using Navigation bar, Toolbar and context menu
The Navigation bar, Toolbar and context menu provide quick access to tools implemented in Grant Manager.
Database
select a database for grants management
General
refresh the content of the window
call Role Editor to add a new user
call Role Editor to edit an existing user
delete a database user
call Role Editor to add a new group
call Role Editor to edit a new group
delete a group
extract selected role's grants
extract all roles' grants
/
show/hide groups in the list
restore the default size and position of the window
Privileges for
select an existing database user/group to grant privileges to
Right-click an item within the Privileges for list to call the context menu allowing you to:
- call Role Editor to add a new user;
- call Role Editor to edit the selected user;
- delete the selected user;
- call Role Editor to add a new group;
- call Role Editor to edit the selected group;
- delete the selected group.
NB: You can enable\disable Toolbars and Navigation bars at Environment options.
The context menu is aimed at facilitating your work: you can perform a variety of operations using context menu items.
The context menu of Grant Manager allows you to:
- grant a permission on an object to the selected role;
- grant a permission (with Grant Option) on an object to the selected role;
- revoke a previously granted permission;
- grant all permissions on an object to the selected role;
- grant all permissions (with Grant Option) on an object to the selected role;
- revoke all previously granted permissions on an object;
- grant a permission on all objects to the selected role;
- grant a permission (with Grant Option) on all objects to the selected role;
- revoke a previously granted permission on all objects;
- apply sorting of objects in grid (by type, name, schema);
- apply sorting of objects in grid (by name, schema);
- apply sorting of objects in grid (by type, schema, name);
- apply sorting of objects in grid (by schema, name).
