For DB2 Web Services to access iSeries databases, you may need to change the default authorizations. You can either change the connection properties or you can grant authorizations to the databases as follows:
Change Connection Properties
By default, the samples connect to the databases using the user profile that the application server is running under. To connect to the databases using a different profile, you must specify the user profile by modifying the connection properties. Refer to DADX Group Properties for additional information on these properties.
Grant Authorizations
If you want to connect to the database using the application server's profile, QEJBSVR by default, you must grant authority to the database. You can do this using the following two iSeries commands:
GRTOBJAUT OBJ(QSYS/myDB_library) OBJTYPE(*LIB) USER(QEJBSVR) AUT(*ALL)
GRTOBJAUT OBJ(myDB_library/*ALL) OBJTYPE(*ALL) USER(QEJBSVR) AUT(*ALL)
Protecting Passwords
By default passwords are stored in the group.properties file in plain text. You can use the Encode utility provided with this sample application to encode the password. To encode the password, from Qshell enter Encode (with no parameters). Encode is located in the same directory as the group.properties file.