How to List Data Query user security information.

Products

• Datacom
• DATACOM - AD
• CIS
• COMMON SERVICES FOR Z/OS
• 90S SERVICES
• DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS
• COMMON PRODUCT SERVICES COMPONENT
• Common Services
• CA ECOMETER SERVER COMPONENT FOC
• Easytrieve Report Generator for Common Services
• INFOCAI MAINTENANCE
• IPC
• UNICENTER JCLCHECK COMMON COMPONENT
• Mainframe VM Product Manager
• CHORUS SOFTWARE MANAGER
• CA ON DEMAND PORTAL
• CA Service Desk Manager - Unified Self Service
• PAM CLIENT FOR LINUX ON MAINFRAME
• MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME
• GRAPHICAL MANAGEMENT INTERFACE
• WEB ADMINISTRATOR FOR TOP SECRET
• Xpertware

Issue/Introduction

Question:

We need to get a report showing the different authorizations that our users have.

Could you tell us how? 

 

Answer:

The following Data Query request will do it:

FIND RELATIONSHIP RELATED BY SUBJ-OCC-NAME VIA ENTITY-NAME TO PERSON 
WITH PERSON.ENTITY-VER = RELATIONSHIP.SUBJ-VRS-NUM AND 
PERSON.STATUS NOT = 'H' AND 
RELATIONSHIP.ENTITY-NAME = 'PER-ATZ-AUTH' AND 
RELATIONSHIP.OBJ-OCC-NAME = '$DQ-#' 
SORT RELATIONSHIP SUBJ-OCC-NAME OBJ-OCC-NAME 
PRINT FROM RELATIONSHIP SUBJ-OCC-NAME 'USER NAME' 
OBJ-OCC-NAME 'AUTHORIZATION' 

The above query provides the following report: 

USER NAME               AUTHORIZATION 
---------------------------- ---------------------------- 
userid                           $DQ-ADDR-tttddd 
userid                           $DQ-UPDR-tttddd 
userid                           $DQ-DELR-tttddd 
userid                           $DQ-DISR-tttddd 

where: 

. userid is the user's id 
. function: 
ADDR means INSERT authority 
UPDR means UPDATE authority 
DELR means DELETE authority 
DISR means FIND authority 
. ttt is the 3 position table name 
. ddd is the dbid number 
----- 

Environment

Release: DATABB00200-14-Datacom/AD
Component: