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 65 shows SQL statements that delete the rows. You can also use the Table Editor, as explained in Using QMF.

Figure 65. 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.

[ Previous Page | Next Page | Contents | Index ]