Power

 View Only
  • 1.  Looking for the best method give all user the ability to use command CHGQRYA.

    Posted Mon April 01, 2024 07:00 PM

    Looking for the best method to give all user the ability to use command CHGQRYA command.  I was asked give *PUBLIC access/allowed via QIBM_DB_SQLADM but that seems like a bad option (?-SQL Admin).  I would prefer to give everyone *JOBCTL Special Authority.  Any thoughts?



    ------------------------------
    michael woodard
    ------------------------------


  • 2.  RE: Looking for the best method give all user the ability to use command CHGQRYA.

    Posted Tue April 02, 2024 07:12 AM

    If you only want the users to be able to change one or two things with CHGQRYA, you could create your own wrapper command MYLIB/MYCHGQRYA and only expose the parameters you want them to control. Then in your command processing program, you would hard-code all the other parameters for CHGQRYA as *SAME. You would make your command processing program run under *OWNER and make the owner of the program a profile that has *JOBCTL or QIBM_DB_SQLADM.



    ------------------------------
    Barbara Morris
    ------------------------------



  • 3.  RE: Looking for the best method give all user the ability to use command CHGQRYA.

    Posted Tue April 02, 2024 09:10 AM

    Thanks. We had adopt authority in place, but the owning user did not have *JOBCTL.  But I know your suggestion would work also, thanks.



    ------------------------------
    michael woodard
    ------------------------------



  • 4.  RE: Looking for the best method give all user the ability to use command CHGQRYA.

    IBM Champion
    Posted Tue April 02, 2024 08:48 AM

    If this is just to run a particular program then you could put the command in that program and have it adopt authority.

    What value are you trying to change and why?



    ------------------------------
    Robert Berendt IBMChampion
    ------------------------------