Re: FGAC where clause question

From: Hans <hans_at_nospam.com>
Date: Mon, 25 Sep 2006 07:34:59 +0200
Message-ID: <ef7pq4$7om$1@emma.aioe.org>

Hi Galen and thanks for you respond!

>>
>> Result := 'idcus in (select idcus from vmo_cust_user where iduser='''
>> || myUser || ''')';
>
> This is bad. You are putting literals in all of your rewritten queries.

You are right. I will use a context (using a logon trigger on database and put several values in context cache because the queries will get more complicated than in my example below) but that is actually not my real problem here. I'm just playing around with the techniqe right now but stepped into this potenital problem. Actually it is doing the exakt correct thing that I want but I suspect performance to go down if I cannot limit the in clause.

>
> Get a trace and see what sql is executed and make sure it is what you
> expect and that you can run it in SQLPLUS.
>

Yes I will do that.

Regards
/Hans Received on Mon Sep 25 2006 - 00:34:59 CDT