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(at)bigpanda(dot)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".