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

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, Received on Fri May 20 2005 - 22:57:23 CDT