Online Documentation for SQL Manager for PostgreSQL
Managing users and roles
Create user
-
Select the Tools | User Manager item of the main menu, then use the
Add User item of navigation bar, toolbar or context menu and define necessary settings in the opened editor.
-
Select the Tools | Grant Manager item of the main menu, then use the Add User item of navigation bar, toolbar or context menu and define necessary settings in the opened editor.
Create role
-
Select the Tools | User Manager item of the main menu, then use the Add User item of navigation bar, toolbar or context menu and disable the Can Login option in the opened editor.
-
Select the Tools | User Manager item of the main menu, then use the Add User item of navigation bar, toolbar or context menu and disable the Can Login option in the opened editor.
Edit user/role
User/role properties can be changed in editor.
You can open object in editor in the following ways:
-
Select the Tools | User Manager item of the main menu, then use the
Edit User item of navigation bar, toolbar or context menu and make needed changes in the opened editor.
-
Select the Tools | Grant Manager item of the main menu, then use the Edit User item of navigation bar, toolbar or context menu and make needed changes in the opened editor.
Renaming user/role
Select the Tools | User Manager item of the main menu, then use the Rename User item of the context menu of the needed object.
Deleting user/role
User/role can be deleted in the following ways:
- Select the Tools | User Manager item of the context menu, then click the Delete user on the navigation bar, toolbar or context menu and confirm deletion in the opened dialog.
- Select the Tools | Grant Manager item of the context menu, then click the Delete user on the navigation bar, toolbar or context menu and confirm deletion in the opened dialog.
