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.