Hi,

you can also grant the procedure/trigger rights to the tables.

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."





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



Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.