GGGGGGG AAAAAAA RRRRRRR UU UU GGGGGGG GG AA AA RR RR UU UU GG GG AA AA RR RR UU UU GG GG GGGG AAAAAAAA RRRRRRRR UU UU GG GGGG GG GG AA AA RR RR U U GG GG GGGGGGG AA AA RR RR UUUUU GGGGGGG GARUG - Georgia RACF Users Group ======================================================================== Dempsey Programs ---------------- ALLOC Allocate SAS Database File BADPER Shows Permits to Non-existant Profiles and IDs DELGROUP Generate RACF Commands to Delete Permissons from a Profile and Remove Users DUPGROUP Duplicates Permissions from One Profile to Another GRPLIST Given a Profile, This Job will Show All Permitted Resources in the Profile and the Connected Userids GRPLIST1 Given a Profile, This Job will Show All Permitted Resources in the Profile IDPER Shows All Resources Permitted to Userids LOADDB1 Run Database Unload and Replace Contents of SAS Database LR Shows All Defined Resources Sorted by Resource Type and Resource Name LRUACC Shows All Defined Resources Sorted by UACC, Resource Type and Resource Name LU Six List User Reports 1) By Userid [using first character of userid] and Name and Attributes, 2) Userids with ADSP, 3) Userids with SPECIAL, 4) Userids with OPER, 5) Userids that are Revoked and 6) Userids that are Unused or Unused for 90 days LUREPT Report for User Profiles Sorted by OWNER Showing Basically the Same Information as in Reports 1, 5 and 6 in LU MOVGROUP Duplicates Permissions from a Profile to a New Profile, Connects Userids to the New Profile and Modifies the Default Profile if Necessary NOCONN Shows Profiles with no Connected Users - Not Complete; Does Not Show All Profiles USERPER Shows All Resources Permitted to a Userid and Connected Profiles Dempsey Program Notes: ---------------------- I started to internally document the programs, but other tasks became a higher priority and time is rapidly passing, so I am sending them 'as is'. All of the following programs make these assumptions: 1. There are NO conditional RACF permits - all permits are treated as unconditional permits. 2. All profiles have an active connection. Revoked and resumed connects are considered as enforced rules. 3. The contents of group profiles (GPIMS, GCICSTRN etc) are not shown. 4. There is a SAS MACRO at the beginning of each program. Change the search criteria to fit your needs. Some of programs give incorrect results (due to the merging of files) if you search for multiple IDs or profiles. 5. The name field of userids is entered as Lastname, Firstname. When you first run these programs cross check the reports with RACF displays so that you are confident that the report is accurate. Depending upon your operating system and SAS proc, the JCL in these programs may have to be modified. I will eventually properly document these programs and will add additional programs to the list as our reporting requirements increase. Feel free to modify these programs to meet your own requirements and pass these programs along to your RACF peers. If you develop a new program, please sent it to me. The SAS programs follow and are separated by 3 lines of @'s. The third line of @'s contains a one word identifier for the job below the line. Enjoy your reports. **** NOTE **** To maintain proper column alignment, commas (,) appeat in column 1. Use your favorite editor. ---------------------------- Release Date: 09/20/95 ========================================================================