Customization of authorize_reply_query

[Phil Mayers]

On 02/10/12 13:35, Václav Pernica wrote:
> Hello
>
> I use the FR just to only authenticate the user. The data are stored
> in Oracle DD. Is there any option how to disable
> authorize_reply_query? The reason is that that DB contains millions
> of records and each query take some some time. Depending on DB load
> is 0.5 seconds but during the peak it goes up 7 seconds.
>
> As the users are authenticated after authorize_check_query, the reply
> query is in my case only delaying the authentication. Maybe there is
> some option how to set some static response for the reply query?

Just set a null query e.g.

select null where 1=0