Tags

, , , , , , , , , ,

Below query that is written against DB2 catalog table will be helpful to see what program has what level of access for a specific DB2 table that you are looking at.

SELECT TCREATOR AS CREATOR
, TTNAME AS TABLE
, GRANTEE AS GRANTEE
, SUBSTR(TTNAME,6,3) AS TBL
, VALUE(USR_USER_NAME,’ ‘) AS “USER NAME”
, VALUE(USR_DEL_IND,’ ‘) AS DEL_IND
, VALUE(USR_DEPT_ID,’ ‘) AS DEPT
, GRANTEETYPE AS TYPE
, SUM(CASE WHEN INSERTAUTH = ‘Y’ THEN 1 ELSE 0 END) *1 AS C
, SUM(CASE WHEN SELECTAUTH = ‘Y’ THEN 1 ELSE 0 END) *3 AS R
, SUM(CASE WHEN UPDATEAUTH = ‘Y’ THEN 1 ELSE 0 END) *5 AS U
, SUM(CASE WHEN DELETEAUTH = ‘Y’ THEN 1 ELSE 0 END) *7 AS D
, ((SUM(CASE WHEN INSERTAUTH = ‘Y’ THEN 1 ELSE 0 END) *1) +
(SUM(CASE WHEN SELECTAUTH = ‘Y’ THEN 1 ELSE 0 END) *3) +
(SUM(CASE WHEN UPDATEAUTH = ‘Y’ THEN 1 ELSE 0 END) *5) +
(SUM(CASE WHEN DELETEAUTH = ‘Y’ THEN 1 ELSE 0 END) *7)) AS TOT
FROM SYSIBM.SYSTABAUTH
WHERE LOCATION = ”
AND GRANTEETYPE = ‘P’
AND TCREATOR = ‘SCHEMA_NAME’
AND TTNAME LIKE ‘TABLE_NAME%’
GROUP BY TCREATOR
, TTNAME
, GRANTEE
, GRANTEETYPE
, USR_USER_NAME
, USR_DEL_IND
, USR_DEPT_ID
WITH UR;

——————————————————————————————————–

If you would like to Earn Free Stocks, Credit card Points and Bank account Bonuses, Please visit My Finance Blog

——————————————————————————————————–

You may also like to look at:

Working on Mainframes – Is Change to a different technology necessary
Important SQL CODES and ABEND CODES
SORT JOIN – TO JOIN TWO FILES BASED ON A KEY
KNOW YOUR MAINFRAME
REXX – INITIAL SETUP
HOW TO SUBMIT A BATCH JOB FROM THE CICS PROGRAM
CICS – EXEC interface block – EIBRESP Values
CICS – EXEC interface block Fields
Flow of control between COBOL programs, run units, and CICS
CICS INTERVIEW QUESTIONS
CICS TIPS
COBOL – COPY and INCLUDE statements
COBOL – PERFORMANCE IMPROVEMENT
COBOL – SIGN STORED IN COMP, COMP-3 AND DISPLAY FORMATS
SHORTEST COBOL PROGRAM
RESTART LOGIC IN COBOL DB2 Program
GOBACK – EXIT PROGRAM – STOP RUN
Continuation lines in COBOL
Computational items – COMP, COMP 1 , COMP 2, COMP 3
COBOL program format
cobol indicator area column-7 and area a and area b
COBOL INTERVIEW QUESTIONS
COBOL TIPS
COBOL COMPILER OPTIONS
The IDENTIFICATION DIVISION