Home » RDBMS Server » Security » Virtual Private Database query (Oracle 10.2.0)
Virtual Private Database query [message #432219] Mon, 23 November 2009 01:11 Go to next message
Messages: 45
Registered: September 2005
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.

Re: Virtual Private Database query [message #432227 is a reply to message #432219] Mon, 23 November 2009 01:46 Go to previous message
Michel Cadot
Messages: 68264
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
A policy rule is attached to a table, Oracle will do what it needs to do to apply it.
But don't trust, try it.

Previous Topic: grant privilege to use for a table
Next Topic: udump permissions to gropu other that dba
Goto Forum:

Current Time: Thu Aug 18 09:43:45 CDT 2022