We are using pb 9.0.1 build 7096 with Oracle 9i. We have
database policies set up in Oracle to limit certain user
id's from seeing other users data. When the application
runs and activates the policy the data is filtered but the
numeric values taken straight from the database are showing
up as "1" or "2" in the datawindow. If I put a computed
field on the datawindow which adds 1 to the numeric field
the value shows 1 more than the expected value. When I run
the datawindow through the development environment (using
preview) logged into the database as one of these users the
results are OK. It sounds like there is something missing
in the communication between PB and Oracle 9i when the
application executes. Any help would be appreciated.