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]




Oracle LazyDBA home page