Audit event history report (BTHAUDIT)
1 BTHAUDIT: AUDIT EVENT HISTORY 11/18/10 16:00:56 PAGE 5
Expands :F-Auth Fail G-Grant/Revoke D-DDL W-Writes R-Reads B-DML Binds
DB2 SSID : DEFF 10.1
Auth Grants, ------- AUDITED OBJECT EVENTS -----
Period Begin Failures Revokes DDL 1st Wrt 1st Read DML BIND
----------------- -------- -------- -------- -------- -------- --------
Time : 11/04/10 20:45:49.568820 Auth : RDABXN Plan : DSNTEP2
GRANT/REVOKE Corr : DBCDBA2 Oper : RDABXN Conn : BATCH
Access : GRANT SQL code : 562
Obj type : PLAN Grant reason : -NONE-
Rid : ACEE Utoken:
Length of failing SQL Statement:
SQL text : GRANT EXECUTE
ON PLAN SCCCAT15 TO RDAUSR8
Time : 11/04/10 20:45:49.570637 Auth : RDABXN Plan : DSNTEP2
GRANT/REVOKE Corr : DBCDBA2 Oper : RDABXN Conn : BATCH
Access : GRANT SQL code : 562
Obj type : PLAN Grant reason : -NONE-
Rid : ACEE Utoken:
Length of failing SQL Statement:
SQL text : GRANT EXECUTE
ON PLAN DSNTIAUL TO RDAUSR8
Time : 11/04/10 20:45:49.772181 Auth : RDABXN Plan : DSNTEP2
GRANT/REVOKE Corr : DBCDBA2 Oper : RDABXN Conn : BATCH
Access : GRANT SQL code : 0
Obj type : USER AUTH Grant reason : SYSADM
Rid : ACEE Utoken:
Length of failing SQL Statement:
SQL text : GRANT CREATEDBA TO RDAUSR8
Time : 11/04/10 20:45:53.077437 Auth : RDAUSR8 Plan : DSNTEP2
GRANT/REVOKE Corr : DBCDBA2B Oper : RDAUSR8 Conn : BATCH
Access : REVOKE SQL code : -552
Obj type : USER AUTH Grant reason : 00
Rid : ACEE Utoken:
Length of failing SQL Statement:
SQL text : REVOKE CREATEDBA
FROM RDAUSR8 BY ALL
Expands :F-Auth Fail G-Grant/Revoke D-DDL W-Writes R-Reads B-DML Binds
DB2 SSID : DEFF 10.1
Auth Grants, ------- AUDITED OBJECT EVENTS -----
Period Begin Failures Revokes DDL 1st Wrt 1st Read DML BIND
----------------- -------- -------- -------- -------- -------- --------
Time : 11/04/10 20:45:49.568820 Auth : RDABXN Plan : DSNTEP2
GRANT/REVOKE Corr : DBCDBA2 Oper : RDABXN Conn : BATCH
Access : GRANT SQL code : 562
Obj type : PLAN Grant reason : -NONE-
Rid : ACEE Utoken:
Length of failing SQL Statement:
SQL text : GRANT EXECUTE
ON PLAN SCCCAT15 TO RDAUSR8
Time : 11/04/10 20:45:49.570637 Auth : RDABXN Plan : DSNTEP2
GRANT/REVOKE Corr : DBCDBA2 Oper : RDABXN Conn : BATCH
Access : GRANT SQL code : 562
Obj type : PLAN Grant reason : -NONE-
Rid : ACEE Utoken:
Length of failing SQL Statement:
SQL text : GRANT EXECUTE
ON PLAN DSNTIAUL TO RDAUSR8
Time : 11/04/10 20:45:49.772181 Auth : RDABXN Plan : DSNTEP2
GRANT/REVOKE Corr : DBCDBA2 Oper : RDABXN Conn : BATCH
Access : GRANT SQL code : 0
Obj type : USER AUTH Grant reason : SYSADM
Rid : ACEE Utoken:
Length of failing SQL Statement:
SQL text : GRANT CREATEDBA TO RDAUSR8
Time : 11/04/10 20:45:53.077437 Auth : RDAUSR8 Plan : DSNTEP2
GRANT/REVOKE Corr : DBCDBA2B Oper : RDAUSR8 Conn : BATCH
Access : REVOKE SQL code : -552
Obj type : USER AUTH Grant reason : 00
Rid : ACEE Utoken:
Length of failing SQL Statement:
SQL text : REVOKE CREATEDBA
FROM RDAUSR8 BY ALL
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*