Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: VIRTUAL PRIVATE DATABASE
"zamba" <CRISTIAN_FERRERO_at_HOTMAIL.COM> writes:
> thanks for your appreciation, the fact is that the model has at least
> over than 1000 entities, so i'm trying to understand if VPD can help
> me. I read the article , but the it doesn 't say anithing about having
> or not the field in all entities. That is my problem, how can VPD
> "filter" any table if i don't have the field "company" (for example) in
> it.
> Tks
>
VPD works by adding additional where clauses to every SQL the accesses
protected tables. So if you don't have a column to filter after, this
table cannot be filtered.
I can imagine having common data across all companies like data on
countries, states, cities and so on. So these tables won't need any
VPD policies.
Of course, every table that holds private data for any company needs
some column to filter.
Hope that helps,
Lothar
-- Lothar Armbrüster | lothar.armbruester_at_t-online.de Hauptstr. 26 | 65346 Eltville |Received on Tue Oct 10 2006 - 11:46:45 CDT