DB2 graphic  QMF Version 8

Preventing users without unique profiles from using QMF

It can be difficult to track individual resource use if several people use QMF under the common, default SYSTEM profile. To restrict use of QMF to users who have unique profiles, delete the SYSTEM rows of Q.PROFILES. Figure 19 shows SQL statements that delete the rows. You can also use the Table Editor, as explained in Using DB2 QMF.

Figure 19. Restricting use of QMF to users who have unique profiles
Base QMF (English)
German NLF
 
 
DELETE FROM Q.PROFILES
DELETE FROM Q.PROFILES
WHERE CREATOR='SYSTEM'
WHERE CREATOR='SYSTEM'
AND TRANSLATION='ENGLISH'
AND TRANSLATION='DEUTSCH'

Note: For both base QMF and NLF environments, always specify a TRANSLATION value when deleting rows from Q.PROFILES, or more rows (across different national language environments) might be deleted than you intend. Additionally, always use a WHERE clause, or all rows of Q.PROFILES are deleted.

After you delete the SYSTEM row of Q.PROFILES, create a unique profile for every QMF user; otherwise, your users will not be able to use QMF.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004