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
Original Message:
Sent: Mon June 10, 2024 10:08 AM
From: Scott Walker
Subject: RACF commands for Db2
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
------------------------------