Does oracle support parameterized views? Basically we'd like to be
able to pass a userid to a view and based on the userid filter the
data.
We can get the userid into a table but the problem is that we don't
know which user id goes with which request (we are using a common
application login, rather than separate user logins). Is there such a
thing as a temporary table for a given session? Or some other way to
guarantee we are pulling the correct userid?
In a nutshell we have the userid in a web application and we need a
way to get it to the database so a view can be created that filters
based on the userid.
Received on Wed Aug 13 2003 - 07:23:26 CDT
