Re: Referential integrity question

This is a known problem with 7.0.x's ri implementation
(for a complete explanation check the archives), it
should be fixed in 7.1 due to go into beta soon.

Stephan Szabo
sszabo@bigpanda.com

On Sun, 5 Nov 2000, Raymond O'Donnell wrote:

> Hi all,
>
> Is this normal? - I have discovered the hard way that permissions
> GRANTed to a user on one table influence that user's ability to
> update another table in a foreign key relationship with it. To be
> specific, here are the relevant bits of the two tables:
>
> create table usertypes (
>    typecode      varchar(16) primary key,
>    description   varchar(64),
> );
>
> grant select on usertypes to webanon;
>
> create table users (
>    uid   varchar(16)      primary key,
>    pwd   varchar(16),
>    typecode   varchar(16) references usertypes
>                           on update cascade
> );
>
> grant select,insert,update,delete on users to webanon;
>
> Now, when user webanon tries to update a field in table "users", the
> update doesn't happen.....however, it DOES happen if I grant update
> permissions to webanon on table "usertypes".