Re: column masking in 10g
- From: "David Boyd" <davidb158@xxxxxxxxxxx>
- To: afatkulin@xxxxxxxxx
- Date: Thu, 01 Mar 2007 12:00:26 -0500
Alexander,
This works great for me. Thanks so much.
Did you have experience on the performance between VPD and view?
Dave
From: "Alexander Fatkulin" <afatkulin@xxxxxxxxx>
To: "David Boyd" <davidb158@xxxxxxxxxxx>
CC: oracle-l@xxxxxxxxxxxxx
Subject: Re: column masking in 10g
Date: Fri, 2 Mar 2007 02:02:29 +1000
That isn't very different from my example. You only need to provide
correct policy function,
e.g.
if (user in ('BOB'))
then
return null; --allow user to see content
else
return '1=0'; --do not show anything
end if;
_________________________________________________________________
Find a local pizza place, movie theater, and more?.then map the best route!
http://maps.live.com/?icid=hmtag1&FORM=MGAC01
--
//www.freelists.org/webpage/oracle-l
Other related posts:
