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

Started by Alvaro Alvarezabout 19 years ago2 messagesbugs
Jump to latest
#1Alvaro Alvarez
alvaro.a.alvarez@gmail.com

The following bug has been logged online:

Bug reference: 2915
Logged by: Alvaro Alvarez
Email address: alvaro.a.alvarez@gmail.com
PostgreSQL version: 8.2.1
Operating system: Windows Vista
Description: Not working: GRANT * TO GROUP *
Details:

Hello.

I am trying to assign connect and temporary privilages to a group and it is
not working. I think i am writing the SQL sentence correctly, but it doesn't
work.

db: a default empty database.
db_group: a group role.

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;

Regards,

Alvaro.

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Alvaro Alvarez (#1)
Re: BUG #2915: Not working: GRANT * TO GROUP *

"Alvaro Alvarez" <alvaro.a.alvarez@gmail.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