Re: Column level Security with VPD
From: Adam Musch <ahmusch_at_gmail.com>
Date: Thu, 11 Feb 2010 09:17:53 -0600
Message-ID: <516d05a1002110717y208253f5r31594782d589416e_at_mail.gmail.com>
It doesn't appear so, at least in 10g. You could, however, have the application reference a view or some sort of COALESCE'd/NVL'd result to turn actual NULL values into logical NULL values.
Date: Thu, 11 Feb 2010 09:17:53 -0600
Message-ID: <516d05a1002110717y208253f5r31594782d589416e_at_mail.gmail.com>
It doesn't appear so, at least in 10g. You could, however, have the application reference a view or some sort of COALESCE'd/NVL'd result to turn actual NULL values into logical NULL values.
On Thu, Feb 11, 2010 at 7:23 AM, Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org> wrote:
> I am looking at column level security using vpd. From the docs, it appears
> that with this implemented, the applicable columns return null instead of a
> value. Is there any way to return a value for these columns since the
> programs will expect some value.
>
>
> Jeffrey Beckstrom
> Database Administrator
> Greater Cleveland Regional Transit Authority
> 1240 W. 6th Street
> Cleveland, Ohio 44113
-- Adam Musch ahmusch_at_gmail.com -- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 11 2010 - 09:17:53 CST