Verified Answers


If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it!  Learn more

  • State Not Answered
  • Replies reply
    1
  • Subscribers subscribers
    9
  • Views views
    192
  • Users 0 members are here
  • Locked Locked

Labels

ChangeMan ZMF  195
ChangeMan SSM  2
Comparex  1
StarTool  2
Related
Options
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Stored procedures in Changeman

MigrationDeletedUser
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?

Labels:

Changeman ZMF
  • 0
    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

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.