Re: VPD and modifying FROM clause

cochrane68_at_hotmail.com wrote:
> We're using an Oracle 9i VPD to control security. The VPD allows
> modification of the WHERE clause, but is there any way to modify the
> FROM clause also?
>
> If we are only able to modify the WHERE clause, we will be forced to
> use a subselect which over time will perform poorly due to data
> proliferation. A modification to the FROM clause would allow us to use
> a JOIN condition, which should perform much better.

Follow Hans' advice.

The demo of advanced rewrite is at:
http://www.psoug.org
click on Morgan's Library
click on DBMS_ADVANCED_REWRITE

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)