Can anyone offer me some suggestions for using Oracle Objects for OLE?

Specifically, I have it working, running the exact SQL that I want to use,
but not with the user password.

Currently, I only have it working with a read-only version of the APPS
password.

I need to be able to run it with a user level password, not exposing the
apps level password to the user commnunity.

Can anyone help me with tips in this area?

Thanks.