36.13. Managing PostgreSQL Groups

PostgreSQL keeps its own internal list of groups, each of which can contain zero or more users. Groups are most useful when assigning object permissions, as they allow you to grant access to a table or view to many users at once. Apart from that, they perform no role in access control or authentication.

To create a group, complete the following steps:

1.
On the module's main page, click on the PostgreSQL Groups icon. Your browser will display a table of existing groups and their members, if any. When PostgreSQL is first installed, no groups are defined.

2.
Click on the Create a new group link to go to the group creation form.

3.
Enter a name consisting of letters, numbers, and the _ character in to the Group name field. No other group or user can have the same name.

4.
Leave the Group ID field unchanged as Webmin automatically chooses the ID.

5.
Select the users who will be members of this group from the Members list. In most browsers, you can Ctrl-Click to select more than one username, or Shift-Click to select an entire range.

6.
Click Create to add the group. Object permissions can now be assigned to it, as explained in Section 36.15 “Editing Object Privileges”.

Just like a user, a group that you have created can be edited by clicking on its name in the list on the PostgreSQL Groups page, changing the name or membership list on the editing form, and hitting Save. It can also be deleted by clicking the Delete button on the same form.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.145.161.180