Re: column masking in 10g

From: David Boyd <davidb158_at_hotmail.com>
Date: Thu, 01 Mar 2007 12:00:26 -0500
Message-ID: <BAY101-F13350F06DD7F8A49B84315EF800@phx.gbl>

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_at_gmail.com>
>To: "David Boyd" <davidb158_at_hotmail.com>
>CC: oracle-l_at_freelists.org
>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

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Mar 01 2007 - 11:00:26 CST