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 will 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
|
Copyright © 2011 CA Technologies.
All rights reserved.
|
|