5 pts.
 How to restrict QMF to execute predefined queries only?
Hi, is there a way to restrict the usage of QMF/390 to predefined queries/procedures only? Some users should not be able to edit or create SQL statements on their own. Thank you very much. Regards Michael

Software/Hardware used:
ASKED: July 25, 2008  8:01 AM
UPDATED: July 29, 2008  5:34 PM

Answer Wiki:
Hello, Chapter 6 of this document will help you with this... http://www.redbooks.ibm.com/redbooks/pdfs/sg245746.pdf 6.9.2 Lists The database administrator might want to restrict the visibility of these objects to a certain number of users. To do this, QMF for Windows allows the creation of predefined lists that the users will see by default when working with the product. Lists are also useful to simplify the day’s work of the users by providing them with a tailored set of QMF for Windows objects by default. If a user starts working with predefined queries, and so on, the usual way would be to use the File -> Open from Server menu. This would open a window that then needs to be modified if the user does not need to see all objects from all users. Creating a predefined list provides an alternative to simplify the work by using the File -> Open menu to see a list of tailored objects. The following steps need to be performed to create and save a predefined list. 1. On the File menu of QMF for Windows, click New -> List to open the windows shown in Figure 121. Make sure to select the correct server to create the list from. If the window does not show the required server (like the ’DB2AIX’ in the sample shown), go to the List -> Set Server menu to set the active server accordingly. 2. You may now specify the owner of the objects that need to be in the list, the object directly by name, and the type of objects to be included in the list. Go to the Redbook above for a complete outline of this information...
Last Wiki Answer Submitted:  July 29, 2008  5:34 pm  by  Tpinky   4,165 pts.
All Answer Wiki Contributors:  Tpinky   4,165 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _