IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

[RACF] How to know the list of profiles.
IBM Mainframe Forums -> All Other Mainframe Topics
Post new topic   This topic is locked: you cannot edit posts or make replies. Quick References
View previous topic :: View next topic  
Author Message
pravin madoori

New User


Joined: 29 Jan 2007
Posts: 25
Location: Hyderabad
PostPosted: Wed May 23, 2007 11:09 am
 Reply with quote
I want to know to the list of dataset profiles to which I have access to.[read/update/alter].


Note:1. If I use LU[list user] command, i get the list of groups to which I am connected. But i want to know the list of dataset profiles to which i have an access.
2. If I use CLAS options 5.6 or 5.1 options, i don't find all dataset profiles. Is there any RACF command to do this.
Back to top
View user's profile Send private message
cpuhawg

Active User


Joined: 14 Jun 2006
Posts: 331
Location: Jacksonville, FL
PostPosted: Wed May 23, 2007 6:09 pm
 Reply with quote
There is no simple method of obtaining this information without the using a front end product like VANGUARD.

You can run program IRRDBU00 against the RACF database which unloads it into a sequential dataset.

Code:

//STEP010  EXEC PGM=IRRDBU00,REGION=48M,PARM=NOLOCKINPUT     
//SYSPRINT DD SYSOUT=*                                       
//INDD1 DD  DISP=SHR,                                         
//          DSN=RACF.DATABASE                                 
//OUTDD DD  DSN=HLQ.IRRDBU00.DUMP,                     
//          DISP=(NEW,CATLG,DELETE),                         
//          UNIT=SYSDA,SPACE=(CYL,(150,50),RLSE),     
//          DCB=(RECFM=VB,LRECL=4096,BLKSIZE=20480)           


The output file will contain a variety of record types. The 0404 will contain dataset profiles with the RACF groups or RACF users that can reference them:

Code:

//ST0404 EXEC PGM=SORT                                       
//SORTIN   DD DSN=HLQ.IRRDBU00.DUMP,DISP=SHR           
//SORTOUT  DD DSN=HLQ.IRRDBU00.C404DSPA,                 
//          DISP=(NEW,CATLG,DELETE),                         
//          UNIT=SYSDA,SPACE=(TRK,(900,150),RLSE),     
//          DCB=(RECFM=VB,LRECL=4096,BLKSIZE=20480)           
//SYSOUT   DD SYSOUT=*                                       
//SYSIN    DD *                                               
 SORT FIELDS=COPY                                             
 INCLUDE COND=(5,4,CH,EQ,C'0404')                             
/*                                                           


The 0505 will contain resource profiles with the RACF groups or RACF users that can reference them.

You will need access to the RACF database in order to run the unload program.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
PostPosted: Wed May 23, 2007 6:39 pm
 Reply with quote
Yes, as stated above, you will need an unload of the RACF database.

The alternative is a REXX exec to list your associated groups, and then to cross reference them against all of the dataset profiles, one by one, checking your uid and/or associated group in the access list.
Back to top
View user's profile Send private message
pravin madoori

New User


Joined: 29 Jan 2007
Posts: 25
Location: Hyderabad
PostPosted: Mon May 28, 2007 4:23 pm
 Reply with quote
cpuhawg,
I am not sure whether VANguard is in our shop.How can I know RACF database name.i think, from your proposed solution, the output will contain whole the RACF profiles & all the user/group information.
Is there any to filter all the other users to get output for my userid or my group[which field/position in output indicate user name]

Expat,
In your solution do i need to manual cross reference. if so, then if there are thousands of profiles it will take lot time for cross reference right.Is it possible to take the output & apply some sort/filtering.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy
PostPosted: Mon May 28, 2007 5:17 pm
 Reply with quote
searching for "racf db2 samples" will give You pointers to some useful tools
One worth investigating would be "RACFICE"
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies. View Bookmarks
All times are GMT + 6 Hours
Forum Index -> All Other Mainframe Topics

 

Similar Topics
Topic Forum Replies
No new posts RACF - Rebuild SETROPTS command which... All Other Mainframe Topics 3
No new posts How to create a list of SAR jobs with... CA Products 3
No new posts RACF cost vs. ACF2 cost IBM Tools 2
No new posts Build dataset list with properties us... PL/I & Assembler 4
No new posts CICS Access to RACF CICS 2
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us