refint/acl problem

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

Browse pgsql-hackers by date

  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