Re: snapshot & privacy

zeb 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

I can think of many ways ... from giving them access through a view to what would be my preference ... fine grained access control using the DBMS_RLS built-in package.

http://www.psoug.org/reference/dbms_rls.html

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)