SQL query to obtain list of IDMS users with SIGNON privilege

book

Article ID: 141136

calendar_today

Updated On:

Products

CA IDMS CA IDMS - Database CA IDMS - ADS

Issue/Introduction

Is there any way to obtain the list of IDMS users with SIGNON privilege using SQL ?

   

Environment

Release : All supported releases

Component : CA IDMS

Resolution

As the security information is stored in a network database in the system catalog with an SQL schema defined on it ,it is possible to use SQL query to get the information.

It is necessary to have the following  SQL schema defined(it might be already in the catalog )

CREATE SCHEMA IDMSSECS 

FOR NONSQL SCHEMA SYSDIRL.IDMSSECS VERSION 1

 DBNAME SYSTEM ;

Then use the below query

SELECT AUTHID ,SUBSTR(RESOURCENAME,1,8) AS "SYSTEM"                          
FROM IDMSSECS.RESOURCEAUTH                                                  
WHERE RESOURCETYPE = 'SYST'  AND OTHERAUTH = 16;

Please note that SUBSTR function above is used to shorten the output and make it more readable

As RESOURCENAME is 60 bytes long ,the above function is used to avoid splitting of output columns into two lines .