The CADB2SED report lists the current status of resources in the DB2 catalog. It shows the users who are granted access to each resource and the current privileges or level of authorization granted. The main purpose of this report is to display the current resource’s status from a DB2 perspective, so that you can compare it to the results of the CA ACF2 Option for DB2 resource validation call.
All entries are sorted, then listed, in this order:
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 CADB2SED DB2 SYNCHRONIZATION UTILITY ‑ DB2 RESOURCE STATUS TRACE BATCH 1 PAGE 1
‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑
USERID RESOURCE RESOURCE ACCESS GRANT
GRANTEE TYPE NAME ALLOWED OPTION
======== ======== =========================== ==================== ==================
RRUS8 BPL BP1 USE
RRUS8 DBS EMPDB01 DISPLAYDB WITH GRANT OPTION
RRUS8 DBS EMPDB01 STARTDB
RRUS8 DBS EMPDB01 STATS
RRUS8 DBS EMPDB01 STOPDB
RRUS8 PLN DSNTIA23 EXECUTE
TEST1 DBS EMPDB01 DBADM
USER1 BPL BP0 USE WITH GRANT OPTION
USER1 BPL BP1 USE WITH GRANT OPTION
USER1 DBS EMPDB01 ALL DB2 OWNER
USER1 SYS SYSADM SYSADM
USER5 SYS SYSADM SYSADM
USER6 DBS EMPDB01 DBADM
This report is empty if the included users had no authorizations in the DB2 catalog for the included resources.
|
Copyright © 2011 CA Technologies.
All rights reserved.
|
|