confusing terms
confusing terms
От:
PG Doc comments form <noreply@postgresql.org>
Дата:
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/static/role-membership.html Description: https://www.postgresql.org/docs/10/static/role-membership.html it says "Once the group role exists, you can add and remove members using the GRANT and REVOKE commands: GRANT group_role TO role1, ... ; REVOKE group_role FROM role1, ... ;" how can you add members to a newly created group role using the above command? shouldn't it be GRANT group_role TO user1 ??
Re: confusing terms
От:
Bruce Momjian <bruce@momjian.us>
Дата:
On Mon, Sep 3, 2018 at 07:17:12AM +0000, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/10/static/role-membership.html > Description: > > https://www.postgresql.org/docs/10/static/role-membership.html > > it says > > "Once the group role exists, you can add and remove members using the GRANT > and REVOKE commands: > > GRANT group_role TO role1, ... ; > REVOKE group_role FROM role1, ... ;" > > how can you add members to a newly created group role using the above > command? shouldn't it be GRANT group_role TO user1 ?? Well, users and groups are both roles. The sentence says below this: You can grant membership to other group roles, too (since there isn't really any distinction between group roles and non-group roles). meaning you can grant group role membership to user and other group roles. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription +