Db2 enhancements for program authorization
Starting in Db2 11, Db2 provides the capability to check whether an application program is authorized to use a plan.
When program authorization is enabled, it is performed in addition to package authorization.
To use package authorization effectively by itself, you need to know in advance which programs or packages use a given plan. If you do not have this information, you need to bind the plan with all collections or packages that are used by any programs that execute the plan. A disadvantage to this approach is that if a user has EXECUTE authority to run the plan, the user can accidentally invoke the wrong program, or can change the program to execute a different set of packages from the intended set.
Program authorization does not have this disadvantage, because it allows a program to run only the plans that you specify.
Program authorization is enabled for a program and its plan if the following conditions are true:
- The plan is bound with the new PROGAUTH(ENABLE) option for BIND PLAN and REBIND PLAN.
- Table SYSIBM.DSNPROGAUTH contains a row for the program and the plan.