Re: Oracle 9i VPD Predicate Function

Chris McMahon wrote:
>
> rjamya wrote:
> > if the policy is not defined as static, it will fire twice. This is the
> > deault behavior from 9i onwards.
> >
>
> Is there an advantage/disadvantage to making it static?

There are pros and cons....(isn't there always)

They were static in 8i and people complained because you might have a predicate that says "allowed to view records between business hours", but because the policy was static, as long as you did it once in business hours, you were allowed to continue on past business hours.

So in 9i, they flicked it over to dynamic, although there is a hidden parameter to revert back to 8i behaviour. In 10g, you can choose yourself.

hth
connor

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------