Re: Automatic WHERE clause on table

Fine Grained Access Control - AKA FGAC is the feature you want.

Beware of mines ! - JL has a nice section on the possible pitfalls.

"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 - 04:56:54 CDT