--- In firebird-support@yahoogroups.com, Svein Erling Tysvær
<svein.erling.tysvaer@k...> wrote:

> > > If one has an input form that is split into two sections, one

for

> > > the 'requester' and one for the 'respondee', is it better to
> > > create two tables, one for each 'section' with access rights

on a

> > > per table level, or create a single table and with access

rights

> > > restricted on a field by field basis (if this is indeed

possible)?

> > Not quite sure what you are trying to achieve here. The

respondee

> > needs to be able to write to fields to reply? So would need full
> > access and the requester would need to see the replies. In any

case,

> > VIEW could be used for a reduced set of fields.
>
> How separate are the processes? Can two requests be anwered by one
> response or one request require zero or multiple responses? If so,

I'd

> go for separate tables (two or three), if not Lesters VIEW

solution is

> good.
>

Have answered this question (I hope) in a reply to Lester.

> > > Any suggestions for a 'Grant Manager' program for use with FB?
> > I use the grant manager in IBOConsole.
>
> And I use Database Workbench. Though Database Workbench is a lot

more

> than a grant manager, and I don't think it is worth the price if

you

> only intend to use it for grants.

I'm using IB Expert Personnel at the moment but it doesn't have a
Grant Manager (in this version).
Ideally it would be nice to find a 'lite' version so that clients
(as well) can set their own access privledges as they see fit. They
wouldn't need all the 'bells and whistles' of IBO Console, Database
Workbench or the full version of IB Expert.

Thanks for the time answering my query,
Tony

>
> HTH,
> Set