Dynamic SQL Package Security
To build the dynamic SQL packages required by CONNX, your OS/400 user ID requires write access to the target library/collection (default = NULLID), plus the BIND and GRANT privileges. The last step in the package-building logic is a
GRANT execute to library.CONX???? to PUBLIC
where:
library is the target library/collection (default = NULLID)
???? is the package suffix as documented in CONNX DB2 Dynamic SQL Packages