Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: 500 users, 10,000 roles: Performance problems to be expected?

Re: 500 users, 10,000 roles: Performance problems to be expected?

From: andrewst <member14183_at_dbforums.com>
Date: Tue, 10 Jun 2003 19:43:58 +0000
Message-ID: <2986592.1055274238@dbforums.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US