From: | Kovacs Zoltan Sandor <tip(at)pc10(dot)radnoti-szeged(dot)sulinet(dot)hu> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | refint/acl problem |
Date: | 2000-06-22 20:54:31 |
Message-ID: | Pine.LNX.4.05.10006222253250.31255-100000@pc10.radnoti-szeged.sulinet.hu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Reference integrity module seems to have a serious bug (I use 7.0).
Although the super user gave a SELECT permission to the simple user
on the table "a" and ALL permission on the table "c" (which references
to the table "a"), the simple user will get an
ERROR: a: Permission denied.
message. My definitions:
test=# create table a(b serial);
test=# grant select on a to simpleuser;
test=# create table c(d int4 not null references a(b));
test=# grant all on c to simpleuser;
Any comments?
Regards,
Zoltan
From | Date | Subject | |
---|---|---|---|
Next Message | Kovacs Zoltan Sandor | 2000-06-22 20:55:21 | problem with ALTER GROUP |
Previous Message | Lamar Owen | 2000-06-22 20:45:39 | Re: Interesting mention of PostgreSQL in news |