How to restrict QMF to execute predefined queries only?

5 pts.
Tags:
IBM DB2
Mainframe
OS/390
QMF
Query Management Facility
z/OS
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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…

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following