StarQuest Technical Documents

Preventing Users from Creating Packages in DB2/400

Last Update: 26 June 2008
Product: StarSQL
Version: 5.x
Article ID: SQV00SQ023


AS/400 database administrators can control a user's ability to create packages by changing the authority on the CRTSQLPKG (Create SQL Package) object.


Once the packages that you wish users to be able to execute have been created and the appropriate authorities granted, a database administrator can prevent users from creating new packages by editing authority on the object CRTSQLPKG (Create SQL Package) in library QSYS. Specific instructions follow:

  • Log onto a terminal session on the AS/400 with QSECOFR or greater authority.
  • At the command line, enter the command:


  • Type "2" in order to edit authority on the object Create SQL Package.

Here, you can grant specific authority to users, add/remove users, or simply change the authority of PUBLIC to *EXCLUDE to prevent users who are not specifically named and are not members of the authorization list from creating packages.

For more information about StarSQL packages, refer to the StarSQL and StarAdmin online help.

For more information about this feature, refer to the IBM technical documentation for your AS/400.


The information in technical documents comes without any warranty or applicability for a specific purpose. The author(s) or distributor(s) will not accept responsibility for any damage incurred directly or indirectly through use of the information contained in these documents. The instructions may need to be modified to be appropriate for the hardware and software that has been installed and configured within a particular organization.  The information in technical documents should be considered only as an example and may include information from various sources, including IBM, Microsoft, and other organizations.