O SELECT abaixo mostra todas as tabelas, quais os programas que as usam e que tipo de ação elas sofrem:

SELECT, INSERT, UPDATE ou DELETE, do sistema solicitado

SELECT STNAME     AS TABELA
,      GRANTEE    AS PROGRAMA
,      DELETEAUTH AS DELETE
,      INSERTAUTH AS INSERT
,      SELECTAUTH AS SELECT
,      UPDATEAUTH AS UPDATE
FROM   SYSIBM.SYSTABAUTH
WHERE  TCREATOR = 'CAD'
AND    GRANTEETYPE = 'P'
AND    (GRANTEE LIKE 'CADPA%'
     OR GRANTEE LIKE 'CADPB%')
ORDER  BY
       STNAME
,      GRANTEE

TABELA              PROGRAMA  DELETE  INSERT  SELECT  UPDATE
------------------  --------  ------  ------  ------  ------ 
CADTB002_DEB_FOLHA  CADPB300          Y       Y       Y     
CADTB002_DEB_FOLHA  CADPB301                  Y       Y     
CADTB002_DEB_FOLHA  CADPB309                  Y             
CADTB002_DEB_FOLHA  CADPB310                  Y                              
CADTB002_DEB_FOLHA  CADPB313                  Y             
CADTB002_DEB_FOLHA  CADPB314                  Y       Y     
CADTB002_DEB_FOLHA  CADPB322                  Y             
CADTB003_AMORTIZA   CADPB306  Y       Y       Y       Y     
CADTB003_AMORTIZA   CADPB315                  Y       Y     
CADTB004_CNTE_DAMP  CADPB320                  Y       Y     
CADTB004_CNTE_DAMP  CADPB324                  Y             
CADTB004_CNTE_DAMP  CADPB325  Y       Y                     
CADTB005_JNCO_DAMP  CADPB318          Y       Y             
CADTB005_JNCO_DAMP  CADPB319                  Y       Y