We update our developer's table authorizations via batch using DDUPDATE:
//DBDQAU EXEC PGM=DDUPDATE
- - - - - - - - - - - - - - -
//SYSIN DD *
-USR datacomadminuserid,password
-BTG AUTHORIZATION,$DQ-ADDR-TBLnnn
-BTG AUTHORIZATION,$DQ-UPDR-TBLnnn
-BTG AUTHORIZATION,$DQ-DELR-TBLnnn
-BTG AUTHORIZATION,$DQ-DISR-TBLnnn
-UPD PERSON,developeruserid (PROD)
1003 RELT,AUTHORIZATION,$DQ-ADDR-TBLnnn (001),PER-ATZ-AUTH
1003 RELT,AUTHORIZATION,$DQ-UPDR-TBLnnn (001),PER-ATZ-AUTH
1003 RELT,AUTHORIZATION,$DQ-DELR-TBLnnn (001),PER-ATZ-AUTH
/*
Original Message:
Sent: 05-23-2019 06:38 AM
From: David Butler
Subject: Re: How to update table and column security authorization in dataquery via batch
Thanks guys, Karina has opened a support case so will go from there.