| 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: | Whole Thread | Raw Message | 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 |