DB2 authorization failures report (BAUDTAUT)
1 BAUDTAUT: DB2 AUTHORIZATION FAILURES 11/18/10 15:58:03 PAGE 1
Group : DB2 SSID: DEFF 10.1
Member:
15:58:00 ------------------------------Authorization Failures by Object Type-----------------------------
Auth Plan Corr Total Buffer Pool DB/OB Plan Tablespace Stogroup Table/View UserAuth Package CollID
-------- -------- ------------ -------- ----------- -------- -------- ---------- -------- ---------- -------- -------- --------
+ RDAUSR8 DSNTEP2 DBCDBA2B 1 0 0 0 0 0 0 1 0 0
+ Time : 11/04/10 20:45:53.077345 Obj Type: USER AUTH Auth Checked: RDAUSR8 Privilege: 0121
Source: . Target : .
ACEE Utoken: 500100070003C0000000000000000000C2D4C3D7D3E7F140D9C4C1E4E2D9F840C2D4C3D7D3E7F140
Length of failing SQL Statement: 40
SQL : REVOKE CREATEDBA
SQL : FROM RDAUSR8 BY A
Group : DB2 SSID: DEFF 10.1
Member:
15:58:00 ------------------------------Authorization Failures by Object Type-----------------------------
Auth Plan Corr Total Buffer Pool DB/OB Plan Tablespace Stogroup Table/View UserAuth Package CollID
-------- -------- ------------ -------- ----------- -------- -------- ---------- -------- ---------- -------- -------- --------
+ RDAUSR8 DSNTEP2 DBCDBA2B 1 0 0 0 0 0 0 1 0 0
+ Time : 11/04/10 20:45:53.077345 Obj Type: USER AUTH Auth Checked: RDAUSR8 Privilege: 0121
Source: . Target : .
ACEE Utoken: 500100070003C0000000000000000000C2D4C3D7D3E7F140D9C4C1E4E2D9F840C2D4C3D7D3E7F140
Length of failing SQL Statement: 40
SQL : REVOKE CREATEDBA
SQL : FROM RDAUSR8 BY A
A sample of the DB2 authorization failures report (BAUDTAUT), produced with the EXPAND statement to show long names, is shown in the following figure.
BAUDTAUT: DB2 AUTHORIZATION FAILURES 05/08/26 14:48:48 PAGE 5
Group : DB2 SSID: DECN 8.1
Member:
------------------------------Authorization Failures by Object Type-----------------------------
Auth Plan Corr Total Buffer Pool DB/OB Plan Tablespace Stogroup Table/View UserAuth Package CollID
-------- -------- ------------ -------- ----------- -------- -------- ---------- -------- ---------- -------- -------- --------
+ DMRQA11 DSNESPRR DMRQA11 4 0 0 3 0 0 1 0 0 0
+ Time : 05/07/01 14:09:42.350838 Obj Type: PLAN Auth Checked: DMRQA11 Privilege: EXECUTE
Source: . DSNESPRR Target : .
ACEE Utoken: 500120060001C0000000000000000000000000000000000000000000000000000000000000000000
Length of failing SQL Statement: 0
SQL :
+ Time : 05/07/01 14:09:57.776327 Obj Type: PLAN Auth Checked: DMRQA11 Privilege: EXECUTE
Source: . DSNESPRR Target : .
ACEE Utoken: 500120060001C0000000000000000000000000000000000000000000000000000000000000000000
Length of failing SQL Statement: 0
SQL :
+ Time : 05/07/01 14:10:13.217427 Obj Type: PLAN Auth Checked: DMRQA11 Privilege: EXECUTE
Source: . DSNESPRR Target : .
ACEE Utoken: 500120060001C0000000000000000000000000000000000000000000000000000000000000000000
Length of failing SQL Statement: 0
SQL :
+ Time : 05/07/01 14:11:22.888545 Obj Type: TABLE OR VIEW Auth Checked: BMCJMB9 Privilege: UPDATE
Source: RDHJMB_R. A21_COMMENT_ABCDEF Target : .
ACEE Utoken: 500120060001C0000000000000000000000000000000000000000000000000000000000000000000
Length of failing SQL Statement: 14418136
SQL : TE RDHJMB_RDHJMB1_RDHJMB2_RDHJMB3_RDHJMB4.A21_COMMENT_ABCDEFGHHIJKLMNOPQRSTUVWXYZ_ABCDEFGHIJKLMNOPQRSTUVWXYZ
TE RDHJMB_RDHJMB1_RDHJMB2_RDHJMB3_RDHJMB4.A21_COMMENT_ABCDEFGHHIJKLMNOPQRSTUVWXYZ_ABCDEFGHIJKLMNOPQRSTUVWXYZ
SET COMMENT_ID_1234567890123456789 = 9
. Long obj A21_COMMENT_ABCDEFGHHIJKLMNOPQRSTUVWXYZ_ABCDEFGHIJKLMNOPQRSTUVWXYZ
+ RDATXL1 DSNESPCS RDATXL1 1 0 0 1 0 0 0 0 0 0
+ Time : 05/07/01 09:01:08.070036 Obj Type: PLAN Auth Checked: RDATXL1 Privilege: EXECUTE
Source: . DSNESPCS Target : .
ACEE Utoken: 500120060001C0000000000000000000000000000000000000000000000000000000000000000000
Length of failing SQL Statement: 0
SQL : N/P
N/P
+ RDATXL1 DSNESPRR RDATXL1 1 0 0 1 0 0 0 0 0 0
+ Time : 05/07/01 09:01:01.837000 Obj Type: PLAN Auth Checked: RDATXL1 Privilege: EXECUTE
Source: . DSNESPRR Target : .
ACEE Utoken: 500120060001C0000000000000000000000000000000000000000000000000000000000000000000
Length of failing SQL Statement: 0
Group : DB2 SSID: DECN 8.1
Member:
------------------------------Authorization Failures by Object Type-----------------------------
Auth Plan Corr Total Buffer Pool DB/OB Plan Tablespace Stogroup Table/View UserAuth Package CollID
-------- -------- ------------ -------- ----------- -------- -------- ---------- -------- ---------- -------- -------- --------
+ DMRQA11 DSNESPRR DMRQA11 4 0 0 3 0 0 1 0 0 0
+ Time : 05/07/01 14:09:42.350838 Obj Type: PLAN Auth Checked: DMRQA11 Privilege: EXECUTE
Source: . DSNESPRR Target : .
ACEE Utoken: 500120060001C0000000000000000000000000000000000000000000000000000000000000000000
Length of failing SQL Statement: 0
SQL :
+ Time : 05/07/01 14:09:57.776327 Obj Type: PLAN Auth Checked: DMRQA11 Privilege: EXECUTE
Source: . DSNESPRR Target : .
ACEE Utoken: 500120060001C0000000000000000000000000000000000000000000000000000000000000000000
Length of failing SQL Statement: 0
SQL :
+ Time : 05/07/01 14:10:13.217427 Obj Type: PLAN Auth Checked: DMRQA11 Privilege: EXECUTE
Source: . DSNESPRR Target : .
ACEE Utoken: 500120060001C0000000000000000000000000000000000000000000000000000000000000000000
Length of failing SQL Statement: 0
SQL :
+ Time : 05/07/01 14:11:22.888545 Obj Type: TABLE OR VIEW Auth Checked: BMCJMB9 Privilege: UPDATE
Source: RDHJMB_R. A21_COMMENT_ABCDEF Target : .
ACEE Utoken: 500120060001C0000000000000000000000000000000000000000000000000000000000000000000
Length of failing SQL Statement: 14418136
SQL : TE RDHJMB_RDHJMB1_RDHJMB2_RDHJMB3_RDHJMB4.A21_COMMENT_ABCDEFGHHIJKLMNOPQRSTUVWXYZ_ABCDEFGHIJKLMNOPQRSTUVWXYZ
TE RDHJMB_RDHJMB1_RDHJMB2_RDHJMB3_RDHJMB4.A21_COMMENT_ABCDEFGHHIJKLMNOPQRSTUVWXYZ_ABCDEFGHIJKLMNOPQRSTUVWXYZ
SET COMMENT_ID_1234567890123456789 = 9
. Long obj A21_COMMENT_ABCDEFGHHIJKLMNOPQRSTUVWXYZ_ABCDEFGHIJKLMNOPQRSTUVWXYZ
+ RDATXL1 DSNESPCS RDATXL1 1 0 0 1 0 0 0 0 0 0
+ Time : 05/07/01 09:01:08.070036 Obj Type: PLAN Auth Checked: RDATXL1 Privilege: EXECUTE
Source: . DSNESPCS Target : .
ACEE Utoken: 500120060001C0000000000000000000000000000000000000000000000000000000000000000000
Length of failing SQL Statement: 0
SQL : N/P
N/P
+ RDATXL1 DSNESPRR RDATXL1 1 0 0 1 0 0 0 0 0 0
+ Time : 05/07/01 09:01:01.837000 Obj Type: PLAN Auth Checked: RDATXL1 Privilege: EXECUTE
Source: . DSNESPRR Target : .
ACEE Utoken: 500120060001C0000000000000000000000000000000000000000000000000000000000000000000
Length of failing SQL Statement: 0
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*