Thread

refint/acl problem

Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu> — 2000-06-22T20:54:31Z

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