Thanks that works.
I granted the role update access on the key column on the master table.

Is there a way to check the role inside the trigger?

----- Original Message -----
From: "Martijn Tonies" <m.tonies@...>
To: <ib-support@yahoogroups.com>
Sent: Saturday, February 09, 2002 8:45 PM
Subject: Re: [ib-support] Role/permission question


> GRANT UPDATE (col1, col2, col3) ON TABLE tablename TO user/role
>
> Martijn Tonies
> InterBase Workbench - the developer tool for InterBase and Firebird
> http://www.interbaseworkbench.com
>
> Upscene Productions
> http://www.upscene.com
>
> "This is an object-oriented system.
> If we change anything, the users object."
>
>
>
>
> I checked the Language Reference but I don't see that it is possibe to
grant
> UPDATE priviliges only to columns.
> Can you give me the side or a little example?
>
>
>
> > Only grant UPDATE priviliges to those two columns.
> >
> > Check the Language Reference for more.
> >
> > Martijn Tonies
> > InterBase Workbench - the developer tool for InterBase and Firebird
> > http://www.interbaseworkbench.com
> >
> > Upscene Productions
> > http://www.upscene.com
> >
> > "This is an object-oriented system.
> > If we change anything, the users object."
> >
> >
> >
> > >
> > > Hi,
> > >
> > > how can I accomplis that a role can only update two fields in a detail
> > > table?
> > > It seems to be a problem with the foreign key.
> > >
> > > Thanks in advance
> > >
> > > Jörg Schiemann