How can I list all DB2 USERS that are connected to a secondary authid with ACF2?
searchcancel
How can I list all DB2 USERS that are connected to a secondary authid with ACF2?
book
Article ID: 117573
calendar_today
Updated On: 10-06-2023
Products
ACF2ACF2 - DB2 OptionACF2 for zVMACF2 - z/OSACF2 - MISC
Issue/Introduction
What ACF2 commands can I use to list all db2 users that are connected to a specific secondary AUTHID.
Environment
Release: Component: ACF2DB
Resolution
The ACF2 records that are used fro secondary authids are XREF(SGP) records. To list a specific entry, issue the following command ACF SET X(SGP) MSYSID(****) LIST GROUP1 END
the following style of output will be displayed... SYS* / GROUP1 LAST CHANGED BY USER02 ON 12/15/17-12:25 INCLUDE(USR0007 USR0008 USR0009 USR001 USR0010 USR0011 USR0019 USR002 USR002*) EXCLUDE(USR0028) SOURCE
The last entry in the example list shows a masked include entry. The list all users that match this mask, enter the following commands
ACF SET LID SET TERSE LIST LIKE(USR002*) END
The following style of output will be returned
USR0020 usr0020 user 0020 ext 20 USR0021 usr0021 user 0021 ext. 21 USR0028 usr0028 user 0028 ext. 28
after ascertaining all users that are included, you can then remove users that are in the EXCLUDE list. In this example US0028 is excluded from the list of users.
You should be able to see all users that are attached to this secondary authid.
The full list of users attached to secondary authid GROUP1 in this example would be.. USR0007 USR0008 USR0009 USR001 USR0010 USR0011 USR0019 USR002 USR0020 USR0021