RACF Authorizations on DB2 Objects



IBM's flagship relational database management system

RACF Authorizations on DB2 Objects

Postby kk12345 » Thu Jan 06, 2011 8:02 pm

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 ??
kk12345
 
Posts: 18
Joined: Sun Dec 26, 2010 6:26 pm
Has thanked: 0 time
Been thanked: 0 time

Re: RACF Authorizations on DB2 Objects

Postby dick scherrer » Fri Jan 07, 2011 3:43 am

Hello,

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

Typically, developers do not have the permissions to do this for new people.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post