Skip site navigation (1) Skip section navigation (2)

Re: BUG #2915: Not working: GRANT * TO GROUP *

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Alvaro Alvarez" <alvaro(dot)a(dot)alvarez(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2915: Not working: GRANT * TO GROUP *
Date: 2007-01-23 06:04:43
Message-ID: 10696.1169532283@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"Alvaro Alvarez" <alvaro(dot)a(dot)alvarez(at)gmail(dot)com> writes:
> I tried, using both the GUI and CLI:
> GRANT CONNECT, TEMPORARY ON DATABASE db TO GROUP db_group;
> But somehow the results was as if i had witten (even though there is no
> db_group user):
> GRANT CONNECT, TEMPORARY ON DATABASE db TO db_group;

Since PG 8.1 we don't really make a distinction between users and
groups --- they're both "roles".  So AFAICS there's not anything wrong
here.

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Dave PageDate: 2007-01-23 10:30:41
Subject: BUG #2924: pg_ctl reports 'server starting' after fatal error
Previous:From: Tom LaneDate: 2007-01-23 05:54:01
Subject: Re: BUG #2914: SELECT query has no destination for result data

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group