Column masking in Oracle 10g

From: query <zzzz20007_at_gmail.com>
Date: Tue, 17 Jul 2007 21:33:03 -0000
Message-ID: <1184707983.961548.142970@o11g2000prd.googlegroups.com>

hi ,

Is it possible to mask a column using Virtual Database Policy (VDP) in Oracle 10g for some specific users?

eg:
table T1 with column (a1, a2).
We have applied masking policy in a1 column for all users expect u2

select a1,a2 from T1;

When user u1 fires the this query he should see NULL values in a1 column but when another user u2 fires this same query, then he should see the contents of a1.

Is this possible???

Thankz in advance... Received on Tue Jul 17 2007 - 16:33:03 CDT