Summary

Table E.1 summarizes the privileges required by the developers and users when different types of SQL statements are used in DB2 LUW, DB2 for iSeries and for zSeries.

Table E.1. Summary of Privileges

	GROUP	DYNAMIC SQLs	STATIC SQLs
LUW	Developers	BINDADD & Table privileges granted to individual developer or to developer group.	BINDADD & Table privileges granted to individual developer or to PUBLIC.
	Users	EXECUTE & Table privileges granted to individual developer or to developer group.	EXECUTE
iSeries	Developers	Administrative Authority or *USE privilege on the CRTPGM command, create in schema for the target schema, INSERT privilege on SYSPARMS, and *EXECUTE on QSYS2 &. Table privileges granted to individual developer or to PUBLIC.	Administrative Authority or *USE privilege on the CRTPGM command, create in schema for the target schema, INSERT privilege on SYSPARMS, and *EXECUTE on QSYS2 &. Table privileges granted to individual developer or to PUBLIC.
	Users	*EXECUTE on the procedure & Table privileges granted to individual developer or to PUBLIC.	*EXECUTE on the procedure.
zSeries (simplified)	Developers (implementers and definers)	BINDADD & Table privileges granted to individual developer or to developer group. & Depends on value of DYNAMICRULES: DEFINEBIND DEFINERUN INVOKEBIND INVOKERUN	BINDADD & Table privileges granted to individual developer or to developer group.
	Users (invokers)	EXECUTE & Table privileges granted to individual developer or to developer group.	EXECUTE