Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: CHALLENGING:: Dynamic OR Session specific Views. Possible?

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

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Fri, 20 May 2005 21:13:14 -0700
Message-ID: <DbydnU58Dqa_KBPfRVn-uQ@comcast.com>

<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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US