Re: grant select,update - bug or feature?

Mon, May 29, 2000 at 08:51:10PM -0700, Stephan Szabo write:
> This is a known issue in the 7.0 foreign key implementation. The short

Thank you, now it's clear for me.

> It's something that will get fixed, it's just a question of how and when.
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
It's just what I want to know :)

> > create table master ( i integer primary key, a text);
> > -- I want to protect this table from updating by 'dbuser'

By the way, how can I make such a protection? Are triggers the only way?

> > create table slave ( j integer references master, b text);
> > -- I want to enable updating this table by 'dbuser'
> >
> > grant select on master to dbuser;
> > grant select,update on slave to dbuser;

--
jk