Re: Automatic WHERE clause on table

"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

There is a paper on using Fine Grained Access Control in the downloads discussion area in the free stuff group on www.robonerd.com. This is also called row level security and virtual private database (VPD).

Mike Ault Received on Mon Oct 21 2002 - 14:21:26 CDT