Originally posted by Dr. Holger Peine
> Yes, I've read about VPDs (that's how Oracle 8.1.7 calls it, anyway).
> Seems like this is the way to go here.
>
> - So, is it feasible to have 500 (or maybe 1000) users, each with
> their own personal VPD (i.e. subset of rows they are allowed to
> read and write)?
>
Yes, that is OK. VPD is achieved by silently adding extra conditions to
the WHERE clause of queries, which refer to context variables set when
the user logs in. It is perfectly reasonable for each user to have a
different context.
--
Posted via http://dbforums.com
Received on Tue Jun 10 2003 - 14:43:58 CDT
