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


Thu, 22 Jun 2000 22:54:31 +0200 (CEST)
Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>
refint/acl problem