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