Listing Dataquery Users table authorizations

Products

• Datacom

Issue/Introduction

This article provides a quick way to list all table authorizations for all Dataquery users when Dataquery is using internal security.

Environment

Dataquery 15.1

Resolution

Run following Dataquery DQL query : 

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