Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

[RACF] How to know the list of profiles.

 
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
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    Post subject: [RACF] How to know the list of profiles.
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    Post subject: Re: [RACF] How to know the list of profiles.
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: 8593
Location: Back in jolly old England

PostPosted: Wed May 23, 2007 6:39 pm    Post subject:
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    Post subject:
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10255
Location: italy

PostPosted: Mon May 28, 2007 5:17 pm    Post subject: Re: [RACF] How to know the list of profiles.
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.    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts member list compare jzhardy TSO/ISPF 6 Fri May 12, 2017 3:18 pm
No new posts find RACF group for access to spooled... jzhardy JCL & VSAM 1 Mon May 08, 2017 11:46 am
No new posts Liberty Angel Server using RACF Keyring martin9 CICS 0 Tue May 02, 2017 5:49 pm
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
No new posts Cobol list of programs being called biswajit.dattagupta COBOL Programming 5 Tue Nov 01, 2016 2:10 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us