Db2

 View Only

  • 1.  RACF commands for Db2

    IBM Champion
    Posted 22 days ago
    Edited by Scott Walker 22 days ago

    Does anyone have examples of RACF commands to see IDs that have privileges on a table? 

    The commands I use are:

    LISTUSER DBA17     
    LISTGRP DBA        

    SEARCH CLASS(GDSNTB) ALL       
    SEARCH CLASS(DSNR) ALL         
    RLIST DSNR D2*.RRSAF AUTHUSER  

    I don't have anything that will show select,insert, update, delete on a table. OR similar for other objects. 

    ------------------------------
    Scott Walker
    Database Engineer IV - Db2 z/OS
    Navy Federal Credit Union
    Pensacola
    ------------------------------



  • 2.  RE: RACF commands for Db2
    Best Answer

    Posted 16 days ago

    hi Scott,

    try something like: RLIST MDSNTB   qual1.qual2.tbname.authority all 

    where authority is INSERT/UPDATE/DELETE/SELECT 

    qual1 could be a datasharing group pattern, qual2 - schema pattern etc 

    Regards

    Dhiren 



    ------------------------------
    Dhiren Chaudhary
    Natwest Group
    ------------------------------

    Original Message


  • 3.  RE: RACF commands for Db2

    IBM Champion
    Posted 15 days ago

    That worked perfectly. 

    RLIST MDSNTB DDD.SSS.TTT.SELECT ALL AUTHUSER

    Where:

    DDD = Db2 data sharing group name. 

    SSS = Table schema

    TTT = Table name 

    .



    ------------------------------
    Scott Walker
    Database Engineer IV - Db2 z/OS
    Navy Federal Credit Union
    Pensacola
    ------------------------------

    Original Message