Parsing Navicat for PostgreSQL database Group designer

Source: Internet
Author: User
Tags postgresql

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.