Could you explain a bit more?

This role can't even select the master and the detail table.
Therefore I created a view with these two fields and the key with select,
update and reference rights.
But now I get the error message: No read/write access to master table.
I think that's because of the foreign key.

I also tried with a SP, but it's the same here.

/Jörg

----- Original Message -----
From: <hans@...>
To: <ib-support@yahoogroups.com>
Sent: Saturday, February 09, 2002 7:19 PM
Subject: Re: [ib-support] Role/permission question


> Simplest might be to use a 'before update trigger'
>
> ===
> Jörg Schiemann wrote:
> >
> > 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