CA ACF2

Expand all | Collapse all

removing sysadm from a scheduled job id

  • 1.  removing sysadm from a scheduled job id

    Posted 04-01-2019 11:35 AM

    Anyone out there using acf2 for db2?  Having a devil of a time removing sysadm from an id that has to create views for another id in a scheduled job.  If I could use program pathing or source in the rules I'd be set. We use e(sgp for secondary auths for nesting purposes but putting the scheduler id in a secondary auth doesn't help with create.

     

    Thanks for any suggestions.

     

     

    Kevin



  • 2.  Re: removing sysadm from a scheduled job id

    Posted 04-02-2019 04:07 PM

    Hi Kevin,

    Is this functionality available with native DB2?

    ACF/DB2 validates the same resources as provided by native DB2.

    Is there a way in DB2 to only allow SYSADM for a scheduled job?

    Can you provide more details of what you mean by "scheduled".

    regards,

    Ross Decent

    Broadcom Support



  • 3.  Re: removing sysadm from a scheduled job id

    Posted 04-03-2019 12:24 PM

    We use ca7 to schedule jobs in this case we the job does a set current sql id to another id before creating new views.  No I don’t know of anything in native db2 security that would handle this issue.

     

    Kevin