MVSFORUMS.com

yadav2005 · Intermediate Joined: 10 Jan 2005 Posts: 348 Topics: 144

I have created a QMF proc and a user is testing to execute the QMF proc but he is not authorised to execute that.Can anyone tell me how can i give authorization to that particular user for executing the QMF PROC.I have the DBA authority.How can i check for the proc which i created have executing authority.

CZerfas · Intermediate Joined: 31 Jan 2003 Posts: 211 Topics: 8

You cannot give execute authorization to particular users. To allow, that your PROC (and QUERY and FORM) can be used by others, you have to save the objects with a parameter "(SHARE=YES".

Additionally you have to prefix the used queries and forms in your PROC with your userid. Otherwise QMF prefixes them implicitly with the userid of the one excuting the PROC.

regards
Christian

yadav2005 · Intermediate Joined: 10 Jan 2005 Posts: 348 Topics: 144

Thanks CZerfas I could understand and I was able to complete my task.