VPD with column masking
From: J. Dex <cemail_219_at_hotmail.com>
Date: Tue, 20 Oct 2009 11:10:06 -0400
Message-ID: <BLU147-W7E72EA6BCDFEBFB30033BA5C00_at_phx.gbl>
Hotmail: Free, trusted and rich email service. http://clk.atdmt.com/GBL/go/171222984/direct/01/
Date: Tue, 20 Oct 2009 11:10:06 -0400
Message-ID: <BLU147-W7E72EA6BCDFEBFB30033BA5C00_at_phx.gbl>
Using VPD with column masking, is it possible to set up a function/policy so it only applies to a small percentage of the users in the database?
I have a main schema with all the tables under that schema. I want a few of the users (not everyone) to only be able to look at some of the data that resides in those tables under that main schema. Is it possible to apply a function and policy to work that way? What is the best way to do that?
Hotmail: Free, trusted and rich email service. http://clk.atdmt.com/GBL/go/171222984/direct/01/
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 20 2009 - 10:10:06 CDT