Re: CHALLENGING:: Dynamic OR Session specific Views. Possible?

On 20 May 2005 20:57:23 -0700, vistav20_at_yahoo.com wrote:

>Thanks very much for help.
>
>Unfortunately they all missed the boat. What I am after is modifying
>the underlying SQL of a view dynamically, for each session.
>
>So, if user 1 logs in, the program might change the view A for him as
>"create or replace view A as select a from table1 where a = 123". While
>if user 2 logs in, the program will issue the following: "create or
>replace view A as select b as a from table2 where a = 567". etc etc
>
>regards,

Agree with Jim on this. Your approach would be unscalable, as your modified view would need to be recompiled every time it is accessed. Apart from that, why aren't you following up the sensible advice already provided in this thread?

--
Sybrand Bakker, Senior Oracle DBA