IBM Mainframe Forum

I have new team member who need access on DB2 Tables / Views which I work on.

I request to provide the READ Access on all tables Dev / PROD modelling my RACF-Id.
But Which does not happened.

Now What is the best way to check,
1) On what objects (interested in Tables & Views) the new team member have access on ?


I got the list of tables using following Query:

SELECT * FROM SYSIBM.SYSTABAUTH WHERE GRANTEE LIKE 'RACFID%'

how to check for Views ??

Hello,

Suggest you talk with your dba and/or security admin.

Typically, developers do not have the permissions to do this for new people.