Re: Column masking in Oracle 10g

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Tue, 17 Jul 2007 04:24:07 GMT
Message-ID: <HvXmi.78896$oh3.21582@newsfe03.phx>

query <zzzz20007_at_gmail.com> wrote in news: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.

In plain English, what does "masked" mean in this context?

>
> select b1 from T1,T2 where a1=a2;
>

Why is T2 in the FROM clause when it contributes nothing to SELECT clause?

SELECT B1 FROM T1
WHERE A1 IN ( SELECT A2 FROM T2); Received on Mon Jul 16 2007 - 23:24:07 CDT