Skip to main content

Stored procedures in Changeman

  • November 11, 2016
  • 1 reply
  • 0 views
D
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

    1 reply

    D
    • Dominique SacreRocketeer
    • Author
    • Rocketeer
    • 19312 replies
    • December 1, 2016
    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


    Terms & ConditionsAccessibility statement