Parsing Navicat for PostgreSQL database Group designer

The Navicat for PostgreSQL database uses users and groups to manage database access permissions, and users have database objects, such as databases, on which you can specify permissions to other users, and control the scope and permissions of other users to access objects. This Navicat tutorial is to parse the NAVICAT for PostgreSQL Database Group designer, the following is introduced to you.

Navicat for PostgreSQL user

PostgreSQL Group designer General Properties

Group Name: Sets the name of the group, which the user can set according to their own needs.

Group ID: Specify an ID for the group. Typically, you do not need to specify an ID for a group unless the user needs to rebuild a group and reference the permissions of some objects. If not specified, the default is the highest specified group ID plus one, and the default minimum is 100.

PostgreSQL Group Designer Members

In the grid, check the "grant" option for users listed under "Members", and specify that the selected user becomes a member of the group and that multiple users are granted support.

PostgreSQL Group Designer Permissions

To edit a specific object permission for a group, click on the "Add Permissions" icon to open the window and follow these steps:

1. Expand the node in the view tree until it reaches the target object.

2. Tick the object and display the grid on the right panel.

3. In the grid, check the "Grant option" to specify that the group has permissions to operate the database, and that it supports granting multiple permissions, in contrast to the permissions listed in the permissions.

Parsing Navicat for PostgreSQL database Group designer