Remote DB connection questions

Hi all,
I'm using an SQLRPGLE program to connect between our test/production
partitions. The goal was to create a program that would run on either box
while accessing only the data from Production all while not having to
hardcode a password into the program. I've almost gotten there using
CRTSQLPKG but have noticed one problem. I must be missing something trivial
in how the RDB connections work. Here's the process I've been using for
testing:

I sign onto the Development box, compile the program with default parameters
& CRTSQLPKG pointing to the Production partition using username/password.
Running the program accesses data on the Production partition as it should.
Good! The trouble is, when any other user runs the program they see data on
the Development partition. It appears as though the only user who is able to
fetch data from the remote DB is the one that created the package. How can
this be the case?

Another question that came up is what happens if the password is changed for
the user defined in the CRTSQLPKG command?
Thanks in advance,

Eric Dalton
Waterford Wedgwood USA


**********************************************************************
This Transmission may contain Privileged and Confidential Information intended only for the use of the named addressee(s). If you are not the intended recipient, You Are Hereby Notified that any dissemination of this communication is strictly prohibited.

If you have received this Transmission in error please notify us and return to Waterford Wedgwood, USA immediately.

Waterford Wedgwood, USA shall bear no responsibility for any inaccurate, incorrect, offensive or misleading information contained herein.

The contents of this specific Transmission should not be construed as representing the opinions or policies of Waterford Wedgwood, USA.

Waterford Wedgwood, USA shall not be liable for any loss or damage arising as a result of any delay or omissions made in connection with this Transmission.
**********************************************************************