OraFAQ Forum: Security » Virtual Private Database query

Home » RDBMS Server » Security » Virtual Private Database query (Oracle 10.2.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Virtual Private Database query [message #432219]

Mon, 23 November 2009 01:11

rawat_me
Messages: 45
Registered: September 2005

Member

I have a query regarding VPD.

I have two table A , B and i am introducing a new column in both tables say not_required_flag .

Now i would like to create a security policy on this new column to add " Where Clause" for get only those records from A, B
where "not_required_flag = "N" " .

I query is:

If i try to Join A and B tables would CBO automatically put alias while Parsing these join condition and including "Where " Predicate.

Report message to a moderator