--- In firebird-support@yahoogroups.com, Lester Caine <lester@l...>
wrote:

> Tony Masefield wrote:
>
> > Somewhere in the documentation on Firebird, I think I saw a

comment

> > that with FB one can assign access rights down to field level?
> I do that with VIEW's - just set up a read only view with the

fields

> that are allowed.
>
> > 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.
>

To explain more fully, the form in this instance is a maintenance
request form.
Input in the first instance is from the 'Requester' for a particular
maintenance task.
In the second instance, the priority set and work done, is filled in
by the maintenance department.
Neither 'user' should have access (write privledges)to the others
input area (I suppose somewhat akin to the normal governmental
form "This area for oficial use only"), but they do obviously need
read privledges to the other's input. Hope this is more clear now.
You are right though, I could just use a View for each input - I'm
new to SQL but I should have thought of this option.
Thanks for the help.

> > Any suggestions for a 'Grant Manager' program for use with FB?
> I use the grant manager in IBOConsole.
>
> --
> Lester Caine
> -----------------------------
> L.S.Caine Electronic Services