Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fyOYR-0003tn-Vj for pgsql-docs@arkaria.postgresql.org; Fri, 07 Sep 2018 21:44:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fyOYP-0006KM-VQ for pgsql-docs@arkaria.postgresql.org; Fri, 07 Sep 2018 21:44:37 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fyOYP-0006KF-Pp for pgsql-docs@lists.postgresql.org; Fri, 07 Sep 2018 21:44:37 +0000 Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1fyOYM-0005wP-P2 for pgsql-docs@lists.postgresql.org; Fri, 07 Sep 2018 21:44:37 +0000 Received: from bruce by momjian.us with local (Exim 4.84_2) (envelope-from ) id 1fyOYK-0004AA-OZ; Fri, 07 Sep 2018 17:44:32 -0400 Date: Fri, 7 Sep 2018 17:44:32 -0400 From: Bruce Momjian To: bad.banana@outlook.com, pgsql-docs@lists.postgresql.org Subject: Re: confusing terms Message-ID: <20180907214432.GG28811@momjian.us> References: <153595903271.31913.5283426348521619234@wrigleys.postgresql.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <153595903271.31913.5283426348521619234@wrigleys.postgresql.org> User-Agent: Mutt/1.5.23 (2014-03-12) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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 +