Intelligent Enterprises of the 21st Century

2017-07-07 02:10:07

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`

Категории

Search