VPD vs Multi Schema vs Partitioning

Hi Oracle Gurus,

We will develope a web based ERP application for a company with multi branch (about 20), with the following requirement :
- a normal user can only see and update data for his branch

• some users from head quarters can see ALL data from ALL branch
• reporting will be per branch, but there should be Consolidation reports

Total user will be 200, but maximum concurrent is 60 users.

We will use JSF(ADF Faces) + BC4J, one database server and one apps server.

The question is :
To meet the requirement above about which user can see which data, what Oracle feature should I use :
is it VPD ?
or should I just use different schema for each branch ? or use Partitioning ?

Thank you for your recommendation,
xtanto Received on Sun Jul 09 2006 - 06:51:06 CDT