Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!central.cox.net!east.cox.net!cox.net!p01!lakeread01.POSTED!53ab2750!not-for-mail
From: Chris McMahon <NOSPAM_cochrane68@hotmail.com>
User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: Oracle 9i VPD Predicate Function
References: <4Z6oe.33725$Fv.7401@lakeread01>   <d7ro2e$e24$1@nwrdmz01.dmz.ncs.ea.ibs-infra.bt.com>   <o7goe.33772$Fv.29970@lakeread01>   <d7s40u$sed$1@nwrdmz03.dmz.ncs.ea.ibs-infra.bt.com>   <IDgoe.33776$Fv.11115@lakeread01> <1117988938.995214.118610@z14g2000cwz.googlegroups.com> <r_Moe.34580$Fv.8598@lakeread01> <42A411A4.55CE@yahoo.com>
In-Reply-To: <42A411A4.55CE@yahoo.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Lines: 18
Message-ID: <MbWoe.34591$Fv.4724@lakeread01>
Date: Mon, 06 Jun 2005 07:11:40 -0400
NNTP-Posting-Host: 68.98.160.251
X-Complaints-To: abuse@cox.net
X-Trace: lakeread01 1118056300 68.98.160.251 (Mon, 06 Jun 2005 07:11:40 EDT)
NNTP-Posting-Date: Mon, 06 Jun 2005 07:11:40 EDT
Organization: Cox Communications
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:244310

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.