Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 9i VPD Predicate Function

Re: Oracle 9i VPD Predicate Function

From: Chris McMahon <NOSPAM_cochrane68_at_hotmail.com>
Date: Mon, 06 Jun 2005 07:11:40 -0400
Message-ID: <MbWoe.34591$Fv.4724@lakeread01>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US