Thread: confusing terms

confusing terms

From
PG Doc comments form
Date:
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

From
Bruce Momjian
Date:
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 +