Re: Automatic WHERE clause on table

"Telemachus" <telemachus_at_ulysseswillreturn.net> wrote in message news:<GbQs9.23040$zX3.61880_at_news.indigo.ie>...
> Fine Grained Access Control - AKA FGAC is the feature you want.
>
> Beware of mines ! - JL has a nice section on the possible pitfalls.
>
>

There is another way to do it, used well before FGAC was implemented. It requires some work, of course. You create a view based on your table. Put where clause you want into the view. You can reference a user using USER pseudocolumn. Then revoke all access to the table itself from users and grant them access to the view.

> "Arkadiusz Kubach" <arkadiusz.kubach_at_NOSPAMneotek.pl> wrote in message
> news:ap0ioa$3jm$1_at_news.tpi.pl...
> > Hi. I heard about it but I don't know where to look for such information
> > because
> > I don't know the name of the function or even is it possible.
> >
> > I'd like to add some automatic permission checking when someone is fireing
> > a query on a table. Permissions are defined in another table and I want
> > server could add
> > a WHERE clause or maybe additional query (not included and known by the
> > user)
> > to check for permissions. It is required to limit a record set which user
> > can get.
> >
> > Is it generally possible? If yes, how to do this?
> >
> > Thanks in advance,
> > Arkus
> >
> >
Received on Mon Oct 21 2002 - 10:45:05 CDT