Is there any way to obtain the list of IDMS users with SIGNON privilege using SQL ?
Release : All supported releases
Component : CA IDMS
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 .