Granting access to the application plan and packages

The QMF application plan and packages enable QMF to run as a Db2® application program. To access QMF, all QMF users need access to the QMF application plan and packages.

At installation time, the EXECUTE privilege is granted to PUBLIC for the QMF plan (named QMF1310 by default) and packages. You can revoke access on the QMF plan from PUBLIC. However, you then must issue an SQL GRANT statement for each individual QMF user, as in the following example.
GRANT EXECUTE ON PLAN qmfplanname TO userid

You can also restrict access to QMF through the QMF profile structure that you create.