Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeedt0.toon.t-online.de!newsmm00.sul.t-online.de!t-online.de!news.t-online.com!not-for-mail From: lothar.armbruester@t-online.de (=?utf-8?q?Lothar_Armbr=C3=BCster?=) Newsgroups: comp.databases.oracle.server Subject: Re: VIRTUAL PRIVATE DATABASE Date: Tue, 10 Oct 2006 18:46:45 +0200 Organization: T-Online Lines: 27 Message-ID: <87slhwazka.fsf@prometeus.none.local> References: <1160421179.650065.182350@k70g2000cwa.googlegroups.com> <1160426786.875792.171470@m73g2000cwd.googlegroups.com> <1160439292.057993.284000@k70g2000cwa.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Trace: news.t-online.com 1160498777 01 27596 J6oYLGBrU-BrS5dv 061010 16:46:17 X-Complaints-To: usenet-abuse@t-online.de X-ID: SAmQhkZeYeqiUVf6Kp80oATUvxRFSxUJ20Uk-VDa7KIl63IPdbTZ65 User-Agent: Gnus/5.1007 (Gnus v5.10.7) Emacs/21.4 (gnu/linux) Cancel-Lock: sha1:/W83nNSatutDN2tZVmWYcw6DTQQ= Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:276951 "zamba" 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@t-online.de Hauptstr. 26 | 65346 Eltville |