The CADB2SES report lists the REVOKE and GRANT statements that are used to synchronize the DB2 catalog. Any warning or error messages for a REVOKE or GRANT statement appear immediately after the SQL statement.
‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑
04/11/99 11.37 CADB2SES DB2 SYNCHRONIZATION UTILITY ‑ DB2 SQL STATEMENT REPORT FOR PROD PAGE 1
‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑
DB2 SQL
STATEMENT
====================================================================================================
REVOKE DISPLAYDB, STARTDB, STOPDB ON DATABASE EMPDB01 FROM RRUS8 BY ALL
REVOKE EXECUTE ON PLAN DSNTIA23 FROM RRUS8 BY ALL
REVOKE DBADM ON DATABASE EMPDB01 FROM TEST1 BY ALL
REVOKE USE OF BUFFERPOOL BP0 FROM USER1 BY ALL
REVOKE SYSADM FROM USER1 BY ALL
REVOKE SYSADM FROM USER5 BY ALL
REVOKE DBADM ON DATABASE EMPDB01 FROM USER6 BY ALL
GRANT EXECUTE ON PLAN DSNESPCS TO RRUS8
GRANT EXECUTE ON PLAN DSNESPRR TO RRUS8
GRANT DBADM ON DATABASE PAYDB01 TO USER1 WITH GRANT OPTION
GRANT DBADM ON DATABASE EMPDB01 TO USER5 WITH GRANT OPTION
GRANT USE OF BUFFERPOOL BP1 TO USER6
GRANT USE OF BUFFERPOOL BP1 TO USER7
GRANT DROP, LOAD, CREATETAP ON DATABASE EMPDB01 TO USER7
GRANT USE OF BUFFERPOOL BP0 TO PUBLIC
GRANT EXECUTE ON PLAN DSNTIA23 TO PUBLIC
The sample report contains the name of the DB2 system against which the SY3 processing was done.
|
Copyright © 2011 CA Technologies.
All rights reserved.
|
|