IVP GRANTEE(S) field
The IVP GRANTEE(S) field specifies the authorization IDs that are to be granted access to objects created and bound by Db2 sample jobs.
| Acceptable values: | at least one valid authorization ID |
|---|---|
| Default: | PUBLIC |
| Update: | option 6 on panel DSNTIPB |
| DSNZPxxx: | none |
Use commas to separate individual IDs. Do not use embedded blanks. You can enter up to 44 characters, including commas. The authorization IDs that you enter in this field are granted the following privileges:
- The USE privilege for STOGROUPs and table spaces that are created by IVP jobs
- The DBADM privilege for databases that are created by IVP jobs
- The DELETE, INSERT, SELECT, and UPDATE privileges for tables and created global temporary tables that are created by IVP jobs
- The EXECUTE privilege for packages and plans that are bound by IVP jobs
- The BIND privilege on most plans that are bound by IVP jobs.
PUBLIC grants the privileges to all users on the current server, including database requests using DRDA access. For regulatory compliance, do not use PUBLIC.
