Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Column masking in Oracle 10g

Column masking in Oracle 10g

From: query <zzzz20007_at_gmail.com>
Date: Tue, 17 Jul 2007 03:27:56 -0000
Message-ID: <1184642876.887939.168530@o11g2000prd.googlegroups.com>


hi,

If i use the column masking policy of Virtual Database Policy(VPD ) in Oracle 10g to mask one column in the table, can i use this column in the join conditions?

eg:
Table T1 has coloumns a1 and b1.
Table T2 has columns a2 and b2.
the a1 column in the table T1 is masked.

select b1 from T1,T2 where a1=a2;

is this possible???

thankz Received on Mon Jul 16 2007 - 22:27:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US