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
------------------------------

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
------------------------------

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:
Sent: Sun June 16, 2024 04:35 AM
From: Dhirendra Chaudhary
Subject: RACF commands for Db2

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
------------------------------