I think your best bet is to run these queries as selectable stored
procedures. That way you can define in the select statement what employee
"level" is requesting the records and only give back the correct ones. Then
normal update statements can be used to update them back to the real table.
Alan

> -----Original Message-----
> From: Matt Nielsen [mailto:mnielsen@...]
> Sent: Saturday, 31 May 2003 9:53 AM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] Record Level Security
>
>
> I want to have a table of employees and a table of record numbers
> that they do or don't have access to and when they run a query I
> don't want them to see the records that they shouldn't.
>
> Eventually I don't want them to see or be able to update ceartain
> fields either but for now just the ability to not see ceartain
> records when they run queries.
>
> Thanks.
> --- In IBObjects@yahoogroups.com, Daniel Rail <daniel@a...> wrote:
> > Hi,
> >
> > At May 30, 2003, 17:37, Matt Nielsen wrote:
> >
> > > Anyone have some really slick way to add record level security to
> an
> > > application? I thought about doing it with views, but didn't
> know if
> > > someone had a way with IBObjects to do this.
> >
> > What do you mean by record level security? Is it blocking records?
> > Is it blocking fields? Is it some fields are not updatable and some
> > are? It depends on what you are exactly looking for.
> >
> > --
> > Best regards,
> > Daniel Rail
> > Senior System Engineer
> > ACCRA Group Inc. (www.accra.ca)
> > ACCRA Med Software Inc. (www.filopto.com)
>
>
>
> __________________________________________________________________
> _________
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
> __________________________________________________________________
> _________
> http://www.ibobjects.com - your IBO community resource for Tech
> Info papers,
> keyword-searchable FAQ, community code contributions and more !
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>