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 <bruce@momjian.us> 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 +