Database Security Products (MOSC)

MOSC Banner

VPD Policies

edited Oct 1, 2013 11:07AM in Database Security Products (MOSC) 4 commentsAnswered
Hello,
oracle 11.2.3

I have a policies on tables, but I have a question, Does  VPD  applicated on materilized views? , But in the documentation says that the VPD reforce segurity on  tables, views, or synonyms but don't mention materializad views.

And also,


I have a table with synonym and I have a user of select  with privilege select on this table,
But when I do a select on table with the user of select, with the function and the policie aplicated,show me a error 'The function has error,', but no show the error.


I have this function :

CREATE OR REPLACE FUNCTION F_HIDE_CARD_NUMBER (

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center