Authorization Change Summary Report and Fields (AUTHCHG)

This report presents all authorization change events according to the combination of OMEGAMON® for DB2® PE identifiers specified.

Use the following command to generate an authorization change summary report. 

 

AUDIT
     REPORT
        LEVEL (SUMMARY)
        TYPE  (AUTHCHG)

Layout of a Member-Scope Audit Authorization Change Summary Report

Here is an example of a member-scope Audit Authorization Change Summary report.
   LOCATION: LOCATI_2                   OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0)                   PAGE: 1-1

      GROUP: GROUP_1                              AUDIT REPORT - SUMMARY                        REQUESTED FROM: NOT SPECIFIED
     MEMBER: MEMBER_2                              AUTHORIZATION CHANGE                                     TO: NOT SPECIFIED
  SUBSYSTEM: SYS2                             ORDER: PRIMAUTH-PLANNAME-OBJECT                      ACTUAL FROM: 01/30/15 04:21:44.17
DB2 VERSION: V10                                       SCOPE: MEMBER                                        TO: 01/30/15 07:19:20.25

                   ORIGINAL     SET CURRENT  END OF   END OF  DISTRIBUTED
PRIMAUTH PLANNAME  AUTHID          SQLID    IDENTIFY  SIGNON  TRANSLATION  TOTAL
-------- -------- --------      ----------- -------- -------- ----------- --------
AUTH_20  PLAN_20  ORAUTH30                2        0        0           2        4
                  XXASP33                 0        2        0           0        2
                  *SUBTOTAL*              2        2        0           2        6

         PLAN_30  ORAUTH30                2        0        0           2        4
                  XXASP33                 0        2        0           0        2
                  *SUBTOTAL*              2        2        0           2        6

         *TOTAL*                          4        4        0           4       12

AUTH_30  PLAN_20  ORAUTH30                2        0        0           2        4
                  XXASP33                 0        2        0           0        2
                  *SUBTOTAL*              2        2        0           2        6

         PLAN_30  ORAUTH30                2        0        0           2        4
                  XXASP33                 0        2        0           0        2
                  *SUBTOTAL*              2        2        0           2        6


         *TOTAL*                          4        4        0           4       12

Field description

The authorization change summary report contains the following fields:

OMEGAMON for Db2 PE Identifiers
The identifiers define the order of the Audit data reported. Up to three OMEGAMON for Db2 PE identifiers are printed:

The default ORDER for this report is PRIMAUTH-PLANNAME-OBJECT, where OBJECT is the original authorization ID.

For group-scope reports, MEMBER is automatically added as the last.

ORIGINAL AUTHID
The original value of the authorization ID as passed to the IDENTIFY or SIGNON authorization exit.

When the input record is IFCID 055 or 169, the value is the ORIGINAL AUTHID from the DB2 correlation header.

SET CURRENT SQLID
The authorization changes due to a SET CURRENT SQLID request. The total number of IFCID 055 records for this set of identifiers.
END OF IDENTIFY
The authorization changes due to an identify request. The total number of IFCID 083 records for this set of identifiers.
END OF SIGNON
The authorization changes due to a signon. The total number of IFCID 087 records for this set of identifiers.
DISTRIBUTED TRANSLATION
The authorization changes due to distributed translation. The total number of IFCID 169 records for this set of identifiers.
TOTAL
All authorization changes. The total number of IFCIDs 55, 83, 87, and 169 for this set of identifiers.