Re: masking column values

p1 and p2 are not any attributes. They represented arbitrary predicates in the example.

For example the query could be

select name, id, dept, sal
from emp
where (sal < 5000)
union
select name, id, dept, null
from emp
where (sal > 5000);

The only point was that the predicates p1 and p2 do not act on the same tuples.

Additionally I cannot use VPD to solve this issue. Im wondering if a good solution exists using views.

Thanks...

Sandeep Received on Fri Feb 11 2005 - 12:09:39 CST