Re: snapshot & privacy

On Tue, 27 Jan 2004 21:34:39 +0100, "zeb" <spam_at_nowhere.com> wrote:

>Hi,
>
>I have a big table with data about several countries
>this table is replicated to the countries through snapshot + dblink .
>My problem is to forbid a country to see the data of the others countries.
>How can I protect a country to query the data from the others countries ?
>Any ideas ?
>
>Oracle 8.1.7.4
>AIX 4.3.3
>
>Thanks in advance
>

Several options:
1 set up a view with country info in the where clause. Set up a synonym up for the view, the synonym name is equal to the original table name
2 Set up a virtual private database (Enterprise Edition required) by setting up a policy etc. Far more flexible.

--
Sybrand Bakker, Senior Oracle DBA