I want to set up stored procedures in our ChangeMan system using native SQL. For the most part I've got it working but for some settings our DBA team want to lock down so users cannot override them. How would I go about doing that?

Just wondered if anyone else has done this?

#ChangeManZMF

Hi Catherine, I had a similar requirement from our DBA team: They wanted ChangeMan to restrict usage of certain keywords in native SQL SPs. The solution was to enhance the promotion and installation process with an additional step for scanning the content of Stored Procedures for these keywords. If any disallowed keywords are found, then the deployment fails and findings are written to job output.
As we anyway have to update the content of native SQL SPs with environment-specific values during deployment by using a REXX, it was the easiest way for us to execute the checking at the same place.

This solution was implemented for ZMF 7.1.x. I assume there are better ways for doing this with new ZMF 8.1.x, eventually by using the new HLLX Exits? ( I don't have much experience with ZMF 8.1.x yet).

I hope this helps.
Regards, Andi

---