Required authorities for QMF administration
To avoid issuing multiple GRANT statements for specific database objects, you must use an authorization ID with DBADM or equivalent authority for most QMF administration and customization tasks. You need this level of authority on any database in which your users store data.
- The QMF control tables are stored in this database.
- When a user issues a SAVE DATA command, the resulting table is stored by default in this
database, in table space DSQTSDEF.
Depending on your installation, users may be creating tables in implicitly created table spaces in the DSQDBDEF table.
If your users will be working with database and QMF objects in a Db2 for Linux®, UNIX, and Windows database, you will need DBADM authority on the DSQTSCTL and DSQTSOBJ database partition groups.
To administer QMF under a different ID from which you installed the product, grant DBADM authority to the new ID.