Page 1 of 1

RACF Authorizations on DB2 Objects

PostPosted: Thu Jan 06, 2011 8:02 pm
by kk12345
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 ??

Re: RACF Authorizations on DB2 Objects

PostPosted: Fri Jan 07, 2011 3:43 am
by dick scherrer
Hello,

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

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