In grant management, an SSID, or subsystem ID, identifies a subsystem
for the group and where to perform the GRANT and REVOKE operations.
Procedure
To manage SSIDs for grant management:
On the DB2 Administration Menu
(ADB2) panel, specify
option Z, and press Enter.
On the System Administration
(ADB2Z) panel, specify option
GM, and press Enter.
On the Grant Management Menu
(ADB2ZGM) panel, specify option
S and optionally any filtering criteria, and press
Enter.
Figure 1. Grant Management Menu
(ADB2ZGM) panel
ADB2ZGM n ----------------- DD1A Grant Management Menu ------------------ 13:53
Option ===> S
Db2 System: DD1A
Db2 SQL ID: ADM001
G - Groups GO - Group objects
P - Privileges GP - Group privileges
S - SSIDs PP - Pending privileges
Enter standard selection criteria:
Name . . . . > Creator . . . >
Type . . . . AUTHID . . . >
Qualifier . . > SSID . . . .
Ends in <=. . > (e.g. n DAYS or n MONTHS)
For SSIDs, you can enter filtering criteria in the
SSID and Creator
fields.
The GM - Manage SSIDs
(ADB2ZGS) panel displays a
list of SSIDs, including your local SSID.
Figure 2. GM - Manage SSIDs
(ADB2ZGS) panel
ADB2ZGS n -------------------- DD1A GM - Manage SSIDs -------- Row 1 to 1 of 1
Command ===> Scroll ===> PAGE
Commands: ADD
Line commands: A - Add D - Delete GO - Group objects I - Interpret
PP - Pending privileges ? - Show all line commands
Created
Sel SSID Location By Created Timestamp
* * * *
--- ---- -------------------------- -------> --------------------------
DD1A LOCAL TS6462 2023-07-14-14.40.26.338556
******************************* END OF DB2 DATA *******************************
Perform any of the following actions as needed to edit your SSIDs: