Re: Column level Security with VPD

From: Adam Musch <>
Date: Thu, 11 Feb 2010 09:17:53 -0600
Message-ID: <>

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 <> 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
Received on Thu Feb 11 2010 - 09:17:53 CST

Original text of this message