Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: CHALLENGING:: Dynamic OR Session specific Views. Possible?
<vistav20_at_yahoo.com> wrote in message
news:1116647843.414593.197830_at_z14g2000cwz.googlegroups.com...
> 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,
>
Why? What is the business need. What you are doing is changing the
definition of the view for everyone.You would be better defining a context
variable and basing the view on that.
Jim
Received on Fri May 20 2005 - 23:13:14 CDT