You could create a context and populate that context with the location
the user wants to work with. Your VPD policy (or, frankly, straight
view definitions), could use that value to restrict the results of the
query.

Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

-----Original Message-----
From: Steve Paff
[mailto:oracledba-ezmlmshield-x48504554.[Email address protected]
Sent: Wednesday, November 02, 2005 2:49 PM
To: LazyDBA Discussion
Subject: Virtual PRivate Directory

I am looking for help with Virtual Private Directory using Oracle 10g
forms
as the front end.



We have set up VPD, with appropriate policies and so forth. The VPD is
designed to allow users to distinguish inventory at various locations.



Some users need the ability to log in and look at one location (i.e., be
associated with 1 VPD policy), then 'switch' to a different location on
the
fly from within a form. In other words, they start out looking at New
York
inventory, then switch to look at inventory in Los Angeles, without
having
to log out and log in as a different user.



The question is, how can I set this from within forms? Is there a way
to
switch the main policy variable from 'New York' to 'LA', more or less
transparently to the user?



Steve Paff

Contemporary Technologies, Inc.



steve.[Email address protected]





--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page