Using the Catalog Synchronization Utility › Using the Catalog Synchronization Utility Reports › Using the CADB2SY2 Reports › CADB2SSV—Synchronization Control Statement Report › CADB2SUA—Security Validation Trace

CADB2SUA—Security Validation Trace

The CADB2SUA report shows a summary of the results of each successful resource validation call. The resource validation calls are performed to determine which users have access to the requested DB2 resources. If a user is not authorized to a resource at any level, no report detail line is produced. All entries are sorted, then listed, in this order:

1. User ID
2. Resource type
3. Resource name

User IDs are listed in the same order as they are in the CADB2SCP Userid Extract Trace report. Resource types and names are listed, for each user ID, in the same order as they are in the CADB2SCP Resource Extract Trace report. See the descriptions of these reports, earlier in this section, for details about sort order.

‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑
 04/11/99 10.05             CADB2SUA DB2 SYNCHRONIZATION UTILITY ‑ SECURITY VALIDATION TRACE       BATCH   1  PAGE   1
‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑

               USERID    RESOURCE  RESOURCE                     ACCESS                OWNER
               GRANTEE   TYPE      NAME                         ALLOWED               OPTION
               ========  ========  ===========================  ====================  ==================

               RRUS8     BPL       BP1                          USE
               RRUS8     DBS       EMPDB01                      STATS
               RRUS8     PLN       DSNESPCS                     EXECUTE
               RRUS8     PLN       DSNESPRR                     EXECUTE
               USER1     BPL       BP1                          USE
               USER1     DBS       EMPDB01                      <NOT CHECKED>
               USER1     DBS       PAYDB01                      DBADM                 OWNER
               USER5     DBS       EMPDB01                      DBADM                 OWNER
               USER6     BPL       BP0                          USE
               USER7     BPL       BP0                          USE
               USER7     DBS       EMPDB01                      CREATETAB
               USER7     DBS       EMPDB01                      CREATETAB
               USER7     DBS       EMPDB01                      CREATETAB
               PUBLIC    BPL       BP0                          USE
               PUBLIC    PLN       DSNTIA23                     EXECUTE

This report is empty if the included users had no authorizations under the CA ACF2 Option for DB2 security for the included resources.