Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 9i VPD Predicate Function
Connor McDonald wrote:
> 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
>
Are there any significant performance advantages/disadvantages? I'm a little worried about the predicate function firing twice. Received on Mon Jun 06 2005 - 06:11:40 CDT
![]() |
![]() |