はじめに
SQL Firewall は、許可されていない SQL の実行をブロックする機能です。
SQLインジェクションの防御・軽減や、認証情報窃盗・内部不正のリスク軽減が期待できます。
アプリケーションから実行されている SQL をキャプチャして許可リストが作成できるため、SQL の棚卸など面倒で不確実な作業が必要ありません。
今回は、ベンチマークツールの Swingbench を実行しながら SQL をキャプチャし許可リストを作成・有効化、サンプルで一つ SQL をブロックし、再度許可リストに追加するという流れを試してみます。
使用する DB は Oracle Autonomous AI Database の Always Free です。
許可リスト作成・有効化
SQL Firewall の有効化
まずは SQL Firewall を有効化します。有効化にはDBMS_SQL_FIREWALL.ENABLEを使用します。
DBA_SQL_FIREWALL_STATUS の STATUS列が ENABLED に変化し、STATUS_UPDATED_ON のタイムスタンプが更新されます。
SQL> select * from DBA_SQL_FIREWALL_STATUS;
STATUS STATUS_UPDATED_ON EXCLUDE_JOBS
___________ ______________________________________ _______________
DISABLED 16-APR-24 02.10.47.849069000 AM GMT Y
SQL>
SQL>
SQL> exec DBMS_SQL_FIREWALL.ENABLE;
PL/SQL procedure successfully completed.
SQL>
SQL>
SQL> select * from DBA_SQL_FIREWALL_STATUS;
★ ★
STATUS STATUS_UPDATED_ON EXCLUDE_JOBS
__________ ______________________________________ _______________
ENABLED 30-OCT-26 04.54.48.304054000 AM GMT Y
SQL>
SQLキャプチャ開始
DBMS_SQL_FIREWALL.CREATE_CAPTUREを使用して SQL のキャプチャを開始します。
DBA_SQL_FIREWALL_CAPTURES と DBA_SQL_FIREWALL_CAPTURE_LOGS でキャプチャの状況を確認できます。
この時点では Swingbench を動かしていないため、キャプチャを開始しても DBA_SQL_FIREWALL_CAPTURE_LOGS にデータは存在しません。
SQL>
SQL> select * from DBA_SQL_FIREWALL_CAPTURES;
no rows selected
SQL>
SQL>
SQL> select * from DBA_SQL_FIREWALL_CAPTURE_LOGS;
no rows selected
SQL>
SQL>
SQL>
SQL> BEGIN
2 DBMS_SQL_FIREWALL.CREATE_CAPTURE (
3 username => 'SOE',
4 top_level_only => TRUE,
5 start_capture => TRUE);
6 END;
7* /
PL/SQL procedure successfully completed.
SQL>
SQL>
SQL> select * from DBA_SQL_FIREWALL_CAPTURES;
USERNAME TOP_LEVEL_ONLY STATUS LAST_STARTED_ON LAST_STOPPED_ON
___________ _________________ __________ ______________________________________ __________________
SOE Y ENABLED 30-OCT-26 04.55.17.427831000 AM GMT
SQL>
SQL>
SQL> select * from DBA_SQL_FIREWALL_CAPTURE_LOGS;
no rows selected ★Swingbench を動かしていないためデータ無し
SQL>
Swingbench を実行します。
PO※ の変化だけ確認したいため、それ以外の値はマスキングしています。(∵ベンチマーク条項)
PO: Process Orders の実行回数
Swingbench
Author : Dominic Giles
Version : 2.7.0.1561
Results will be written to results.xml
Hit Return to Terminate Run...
Time Users TPM TPS NCR UCD BP OP PO BO SQ WQ WA
04:55:40 [0/1] x x x x x x 0 x x x x
04:55:41 [1/1] x x x x x x 0 x x x x
04:55:42 [1/1] xx xx x xx x xx 0 xx x x x
04:55:43 [1/1] xxx xxx x x x x 8 x x x x
04:55:44 [1/1] xxx xxx x x x x 5 x x x x
04:55:45 [1/1] xxx xxx x x x x 5 x x x x
04:55:46 [1/1] xxx xxx x x x x 5 x x x x
04:55:47 [1/1] xxxx xxx x x x x 5 x x x x
04:55:48 [1/1] xxxx xxx x x x x 5 x x x x
04:55:49 [1/1] xxxx xxx x x x x 5 x x x x
04:55:50 [1/1] xxxx xxx x x x x 5 x x x x
DBA_SQL_FIREWALL_CAPTURE_LOGS を参照すると、SQL がキャプチャされていることが確認できます。
SQL>
SQL> select * from DBA_SQL_FIREWALL_CAPTURES;
USERNAME TOP_LEVEL_ONLY STATUS LAST_STARTED_ON LAST_STOPPED_ON
___________ _________________ __________ ______________________________________ __________________
SOE Y ENABLED 30-OCT-26 04.55.17.427831000 AM GMT
SQL>
SQL>
SQL> select * from DBA_SQL_FIREWALL_CAPTURE_LOGS;
USERNAME SESSION_ID COMMAND_TYPE SQL_SIGNATURE SQL_TEXT ACCESSED_OBJECTS CURRENT_USER TOP_LEVEL CLIENT_PROGRAM OS_USER IP_ADDRESS
___________ ______________________ _______________ ___________________________________________________________________ ___________________________________________________________________________ ________________________________ _______________ ____________ ___________________ __________ ______________
SOE 7702320072726413316 SELECT 8B15698920B663C4E9916B600DADF877C0E7F01B88774F09C39088F62A82CC69 SELECT :"SYS_B_0" FROM USER_TABLES WHERE TABLE_NAME=:"SYS_B_1" "SYS"."USER_TABLES" SOE Y JDBC Thin Client opc xxx.xxx.xxx.xxx
SOE 7702320072726413316 EXECUTE A9EDAECAC2F1D8076B3E9C7B6B5B6CB6B4B62FD43A0D867D3D522C103AC3E455 BEGIN :1 :=ORDERENTRY.BROWSEPRODUCTS (:2,:3,:4); END; "SOE"."ORDERENTRY" SOE Y JDBC Thin Client opc xxx.xxx.xxx.xxx
SOE 7702320072726413316 EXECUTE 9D6E8DE6D0085F2702F07AAFF0E14DE5AE89490772112DD20F83A2E61F4E7CDE BEGIN :1 :=ORDERENTRY.BROWSEANDUPDATEORDERS (:2,:3,:4); END; "SOE"."ORDERENTRY" SOE Y JDBC Thin Client opc xxx.xxx.xxx.xxx
SOE 7702320072726413316 EXECUTE C6124DA5BD26E22D3E440C96B3C80BFE548ECF02472BE543141CA64918373AEB BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO (?); END; "SYS"."DBMS_APPLICATION_INFO" SOE Y JDBC Thin Client opc xxx.xxx.xxx.xxx
SOE 7702320068187389956 EXECUTE C6124DA5BD26E22D3E440C96B3C80BFE548ECF02472BE543141CA64918373AEB BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO (?); END; "SYS"."DBMS_APPLICATION_INFO" SOE Y JDBC Thin Client opc xxx.xxx.xxx.xxx
SOE 7702320072726413316 EXECUTE B66E03A01CA6EE0E68FD63BB5129C0A06450F830EBBBEB44C964BAC005B6F591 BEGIN ORDERENTRY.SETPLSQLCOMMIT (:1); END; "SOE"."ORDERENTRY" SOE Y JDBC Thin Client opc xxx.xxx.xxx.xxx
SOE 7702320072726413316 EXECUTE CADD8AF0C261DE99B260EC71AA41F3DEA94BC0BD8AA4B5F9E40FF1B40828DA2C BEGIN :1 :=ORDERENTRY.NEWCUSTOMER (:2,:3,:4,:5,:6,:7,:8,:9,:10); END; "SOE"."ORDERENTRY" SOE Y JDBC Thin Client opc xxx.xxx.xxx.xxx
SOE 7702320072726413316 EXECUTE 3240800754A97F3AEDCB1B8C373DB2484C4F2FDF969BECDBAC957A1813BAB556 BEGIN :1 :=ORDERENTRY.UPDATECUSTOMERDETAILS (:2,:3,:4,:5,:6,:7,:8); END; "SOE"."ORDERENTRY" SOE Y JDBC Thin Client opc xxx.xxx.xxx.xxx
SOE 7702320072726413316 EXECUTE AA22947E9B37404FF686E8B95E62376458F3440EA8BBA5BE9E2272B00268C303 BEGIN :1 :=ORDERENTRY.NEWORDER (:2,:3,:4); END; "SOE"."ORDERENTRY" SOE Y JDBC Thin Client opc xxx.xxx.xxx.xxx
SOE 7702320072726413316 EXECUTE 5C952C6E4EED095251FD98FD6F13F074EAFBB4614AB8D4A2E1B78EE7A06BC600 BEGIN :1 :=ORDERENTRY.PROCESSORDERS (:2,:3,:4); END; "SOE"."ORDERENTRY" SOE Y JDBC Thin Client opc xxx.xxx.xxx.xxx
SOE 7702320072726413316 SELECT 79CC743EE363521BA20A1B9791F763511216D5399943F49551FC36BBCF17D57F SELECT METADATA_KEY,METADATA_VALUE FROM ORDERENTRY_METADATA "SOE"."ORDERENTRY_METADATA" SOE Y JDBC Thin Client opc xxx.xxx.xxx.xxx
11 rows selected.
SQL>
SQL>
キャプチャ停止
DBMS_SQL_FIREWALL.STOP_CAPTUREで SQL のキャプチャを停止します。
SQL> exec DBMS_SQL_FIREWALL.STOP_CAPTURE('SOE');
PL/SQL procedure successfully completed.
SQL>
SQL>
SQL> select * from DBA_SQL_FIREWALL_CAPTURES;
USERNAME TOP_LEVEL_ONLY STATUS LAST_STARTED_ON LAST_STOPPED_ON
___________ _________________ ___________ ______________________________________ ______________________________________
SOE Y DISABLED 30-OCT-26 04.55.17.427831000 AM GMT 30-OCT-26 04.57.11.166721000 AM GMT
SQL>
SQL>
SQL> select * from DBA_SQL_FIREWALL_CAPTURE_LOGS;
USERNAME SESSION_ID COMMAND_TYPE SQL_SIGNATURE SQL_TEXT ACCESSED_OBJECTS CURRENT_USER TOP_LEVEL CLIENT_PROGRAM OS_USER IP_ADDRESS
___________ ______________________ _______________ ___________________________________________________________________ ___________________________________________________________________________ ________________________________ _______________ ____________ ___________________ __________ ______________
SOE 7702320072726413316 SELECT 8B15698920B663C4E9916B600DADF877C0E7F01B88774F09C39088F62A82CC69 SELECT :"SYS_B_0" FROM USER_TABLES WHERE TABLE_NAME=:"SYS_B_1" "SYS"."USER_TABLES" SOE Y JDBC Thin Client opc xxx.xxx.xxx.xxx
SOE 7702320072726413316 EXECUTE A9EDAECAC2F1D8076B3E9C7B6B5B6CB6B4B62FD43A0D867D3D522C103AC3E455 BEGIN :1 :=ORDERENTRY.BROWSEPRODUCTS (:2,:3,:4); END; "SOE"."ORDERENTRY" SOE Y JDBC Thin Client opc xxx.xxx.xxx.xxx
SOE 7702320072726413316 EXECUTE 9D6E8DE6D0085F2702F07AAFF0E14DE5AE89490772112DD20F83A2E61F4E7CDE BEGIN :1 :=ORDERENTRY.BROWSEANDUPDATEORDERS (:2,:3,:4); END; "SOE"."ORDERENTRY" SOE Y JDBC Thin Client opc xxx.xxx.xxx.xxx
SOE 7702320072726413316 EXECUTE C6124DA5BD26E22D3E440C96B3C80BFE548ECF02472BE543141CA64918373AEB BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO (?); END; "SYS"."DBMS_APPLICATION_INFO" SOE Y JDBC Thin Client opc xxx.xxx.xxx.xxx
SOE 7702320068187389956 EXECUTE C6124DA5BD26E22D3E440C96B3C80BFE548ECF02472BE543141CA64918373AEB BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO (?); END; "SYS"."DBMS_APPLICATION_INFO" SOE Y JDBC Thin Client opc xxx.xxx.xxx.xxx
SOE 7702320072726413316 EXECUTE B66E03A01CA6EE0E68FD63BB5129C0A06450F830EBBBEB44C964BAC005B6F591 BEGIN ORDERENTRY.SETPLSQLCOMMIT (:1); END; "SOE"."ORDERENTRY" SOE Y JDBC Thin Client opc xxx.xxx.xxx.xxx
SOE 7702320072726413316 EXECUTE CADD8AF0C261DE99B260EC71AA41F3DEA94BC0BD8AA4B5F9E40FF1B40828DA2C BEGIN :1 :=ORDERENTRY.NEWCUSTOMER (:2,:3,:4,:5,:6,:7,:8,:9,:10); END; "SOE"."ORDERENTRY" SOE Y JDBC Thin Client opc xxx.xxx.xxx.xxx
SOE 7702320072726413316 EXECUTE 3240800754A97F3AEDCB1B8C373DB2484C4F2FDF969BECDBAC957A1813BAB556 BEGIN :1 :=ORDERENTRY.UPDATECUSTOMERDETAILS (:2,:3,:4,:5,:6,:7,:8); END; "SOE"."ORDERENTRY" SOE Y JDBC Thin Client opc xxx.xxx.xxx.xxx
SOE 7702320072726413316 EXECUTE AA22947E9B37404FF686E8B95E62376458F3440EA8BBA5BE9E2272B00268C303 BEGIN :1 :=ORDERENTRY.NEWORDER (:2,:3,:4); END; "SOE"."ORDERENTRY" SOE Y JDBC Thin Client opc xxx.xxx.xxx.xxx
SOE 7702320072726413316 EXECUTE 5C952C6E4EED095251FD98FD6F13F074EAFBB4614AB8D4A2E1B78EE7A06BC600 BEGIN :1 :=ORDERENTRY.PROCESSORDERS (:2,:3,:4); END; "SOE"."ORDERENTRY" SOE Y JDBC Thin Client opc xxx.xxx.xxx.xxx
SOE 7702320072726413316 SELECT 79CC743EE363521BA20A1B9791F763511216D5399943F49551FC36BBCF17D57F SELECT METADATA_KEY,METADATA_VALUE FROM ORDERENTRY_METADATA "SOE"."ORDERENTRY_METADATA" SOE Y JDBC Thin Client opc xxx.xxx.xxx.xxx
11 rows selected.
SQL>
許可リスト作成
DBMS_SQL_FIREWALL.GENERATE_ALLOW_LISTで許可リストを作成します。
作成後に DBA_SQL_FIREWALL_ALLOWED_SQL を参照すると、DBA_SQL_FIREWALL_CAPTURE_LOGS の SQL が登録されていることがわかります。
SQL>
SQL> select * from DBA_SQL_FIREWALL_ALLOWED_SQL;
no rows selected
SQL>
SQL>
SQL> exec DBMS_SQL_FIREWALL.GENERATE_ALLOW_LIST('SOE');
PL/SQL procedure successfully completed.
SQL>
SQL>
SQL>
SQL> select * from DBA_SQL_FIREWALL_ALLOWED_SQL;
USERNAME ALLOWED_SQL_ID SQL_SIGNATURE SQL_TEXT ACCESSED_OBJECTS CURRENT_USER TOP_LEVEL VERSION
___________ _________________ ___________________________________________________________________ ___________________________________________________________________________ ________________________________ _______________ ____________ __________
SOE 3 8B15698920B663C4E9916B600DADF877C0E7F01B88774F09C39088F62A82CC69 SELECT :"SYS_B_0" FROM USER_TABLES WHERE TABLE_NAME=:"SYS_B_1" "SYS"."USER_TABLES" SOE Y 1
SOE 5 A9EDAECAC2F1D8076B3E9C7B6B5B6CB6B4B62FD43A0D867D3D522C103AC3E455 BEGIN :1 :=ORDERENTRY.BROWSEPRODUCTS (:2,:3,:4); END; "SOE"."ORDERENTRY" SOE Y 1
SOE 9 9D6E8DE6D0085F2702F07AAFF0E14DE5AE89490772112DD20F83A2E61F4E7CDE BEGIN :1 :=ORDERENTRY.BROWSEANDUPDATEORDERS (:2,:3,:4); END; "SOE"."ORDERENTRY" SOE Y 1
SOE 1 C6124DA5BD26E22D3E440C96B3C80BFE548ECF02472BE543141CA64918373AEB BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO (?); END; "SYS"."DBMS_APPLICATION_INFO" SOE Y 1
SOE 2 B66E03A01CA6EE0E68FD63BB5129C0A06450F830EBBBEB44C964BAC005B6F591 BEGIN ORDERENTRY.SETPLSQLCOMMIT (:1); END; "SOE"."ORDERENTRY" SOE Y 1
SOE 8 CADD8AF0C261DE99B260EC71AA41F3DEA94BC0BD8AA4B5F9E40FF1B40828DA2C BEGIN :1 :=ORDERENTRY.NEWCUSTOMER (:2,:3,:4,:5,:6,:7,:8,:9,:10); END; "SOE"."ORDERENTRY" SOE Y 1
SOE 6 3240800754A97F3AEDCB1B8C373DB2484C4F2FDF969BECDBAC957A1813BAB556 BEGIN :1 :=ORDERENTRY.UPDATECUSTOMERDETAILS (:2,:3,:4,:5,:6,:7,:8); END; "SOE"."ORDERENTRY" SOE Y 1
SOE 7 AA22947E9B37404FF686E8B95E62376458F3440EA8BBA5BE9E2272B00268C303 BEGIN :1 :=ORDERENTRY.NEWORDER (:2,:3,:4); END; "SOE"."ORDERENTRY" SOE Y 1
SOE 10 5C952C6E4EED095251FD98FD6F13F074EAFBB4614AB8D4A2E1B78EE7A06BC600 BEGIN :1 :=ORDERENTRY.PROCESSORDERS (:2,:3,:4); END; "SOE"."ORDERENTRY" SOE Y 1
SOE 4 79CC743EE363521BA20A1B9791F763511216D5399943F49551FC36BBCF17D57F SELECT METADATA_KEY,METADATA_VALUE FROM ORDERENTRY_METADATA "SOE"."ORDERENTRY_METADATA" SOE Y 1
10 rows selected.
SQL>
許可リスト有効化
DBMS_SQL_FIREWALL.ENABLE_ALLOW_LISTで許可リストを有効化します。
SQL>
SQL> BEGIN
2 DBMS_SQL_FIREWALL.ENABLE_ALLOW_LIST(
3 username => 'SOE',
4 enforce => DBMS_SQL_FIREWALL.ENFORCE_ALL,
5 block => TRUE);
6 END;
7* /
PL/SQL procedure successfully completed.
SQL>
SQL>
SQL> select * from DBA_SQL_FIREWALL_ALLOWED_SQL;
USERNAME ALLOWED_SQL_ID SQL_SIGNATURE SQL_TEXT ACCESSED_OBJECTS CURRENT_USER TOP_LEVEL VERSION
___________ _________________ ___________________________________________________________________ ___________________________________________________________________________ ________________________________ _______________ ____________ __________
SOE 3 8B15698920B663C4E9916B600DADF877C0E7F01B88774F09C39088F62A82CC69 SELECT :"SYS_B_0" FROM USER_TABLES WHERE TABLE_NAME=:"SYS_B_1" "SYS"."USER_TABLES" SOE Y 1
SOE 5 A9EDAECAC2F1D8076B3E9C7B6B5B6CB6B4B62FD43A0D867D3D522C103AC3E455 BEGIN :1 :=ORDERENTRY.BROWSEPRODUCTS (:2,:3,:4); END; "SOE"."ORDERENTRY" SOE Y 1
SOE 9 9D6E8DE6D0085F2702F07AAFF0E14DE5AE89490772112DD20F83A2E61F4E7CDE BEGIN :1 :=ORDERENTRY.BROWSEANDUPDATEORDERS (:2,:3,:4); END; "SOE"."ORDERENTRY" SOE Y 1
SOE 1 C6124DA5BD26E22D3E440C96B3C80BFE548ECF02472BE543141CA64918373AEB BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO (?); END; "SYS"."DBMS_APPLICATION_INFO" SOE Y 1
SOE 2 B66E03A01CA6EE0E68FD63BB5129C0A06450F830EBBBEB44C964BAC005B6F591 BEGIN ORDERENTRY.SETPLSQLCOMMIT (:1); END; "SOE"."ORDERENTRY" SOE Y 1
SOE 8 CADD8AF0C261DE99B260EC71AA41F3DEA94BC0BD8AA4B5F9E40FF1B40828DA2C BEGIN :1 :=ORDERENTRY.NEWCUSTOMER (:2,:3,:4,:5,:6,:7,:8,:9,:10); END; "SOE"."ORDERENTRY" SOE Y 1
SOE 6 3240800754A97F3AEDCB1B8C373DB2484C4F2FDF969BECDBAC957A1813BAB556 BEGIN :1 :=ORDERENTRY.UPDATECUSTOMERDETAILS (:2,:3,:4,:5,:6,:7,:8); END; "SOE"."ORDERENTRY" SOE Y 1
SOE 7 AA22947E9B37404FF686E8B95E62376458F3440EA8BBA5BE9E2272B00268C303 BEGIN :1 :=ORDERENTRY.NEWORDER (:2,:3,:4); END; "SOE"."ORDERENTRY" SOE Y 1
SOE 10 5C952C6E4EED095251FD98FD6F13F074EAFBB4614AB8D4A2E1B78EE7A06BC600 BEGIN :1 :=ORDERENTRY.PROCESSORDERS (:2,:3,:4); END; "SOE"."ORDERENTRY" SOE Y 1
SOE 4 79CC743EE363521BA20A1B9791F763511216D5399943F49551FC36BBCF17D57F SELECT METADATA_KEY,METADATA_VALUE FROM ORDERENTRY_METADATA "SOE"."ORDERENTRY_METADATA" SOE Y 1
10 rows selected.
SQL>
SQL>
ここまで、Swingbench の実行には影響がありません。
長いので折り畳み
04:55:51 [1/1] xxxx xxx x x x x 4 x x x x
04:55:52 [1/1] xxxx xxx x x x x 4 x x x x
04:55:53 [1/1] xxxx xxx x x x x 4 x x x x
04:55:54 [1/1] xxxx xxx x x x x 4 x x x x
04:55:55 [1/1] xxxx xxx x x x x 5 x x x x
04:55:56 [1/1] xxxx xxx x x x x 4 x x x x
04:55:57 [1/1] xxxx xxx x x x x 4 x x x x
04:55:58 [1/1] xxxx xxx x x x x 4 x x x x
04:55:59 [1/1] xxxx xxx x x x xx 4 x x x x
04:56:00 [1/1] xxxx xxx x x x x 4 x x x x
04:56:01 [1/1] xxxx xxx x x x x 4 x x x x
04:56:02 [1/1] xxxx xxx x x x x 5 x x x x
04:56:03 [1/1] xxxx xxx x x x x 4 x x x x
04:56:04 [1/1] xxxx xxx x x x x 4 x x x x
04:56:05 [1/1] xxxx xxx x x x x 4 x x x x
04:56:06 [1/1] xxxx xxx x x x x 4 x x x x
04:56:07 [1/1] xxxx xxx x x x x 4 x x x x
04:56:08 [1/1] xxxx xxx x x x x 4 x x x x
04:56:09 [1/1] xxxx xxx x x x x 4 x x x x
04:56:10 [1/1] xxxx xxx x x x x 4 x x x x
04:56:11 [1/1] xxxx xxx x x x x 4 x x x x
04:56:12 [1/1] xxxx xxx x x x x 4 x x x x
04:56:13 [1/1] xxxx xxx x x x x 4 x x x x
04:56:14 [1/1] xxxx xxx x x x x 4 x x x x
04:56:15 [1/1] xxxx xxx x x x x 4 x x x x
04:56:16 [1/1] xxxx xxx x x x x 4 x x x x
04:56:17 [1/1] xxxx xxx x x x x 4 x x x x
04:56:18 [1/1] xxxx xxx x x x x 4 x x x x
04:56:19 [1/1] xxxx xxx x x x x 4 x x x x
04:56:20 [1/1] xxxx xxx x x x x 4 x x x x
04:56:21 [1/1] xxxx xxx x x x x 4 x x x x
04:56:22 [1/1] xxxx xxx x x x x 4 x x x x
04:56:23 [1/1] xxxx xxx x x x x 4 x x x x
04:56:24 [1/1] xxxx xxx x x x x 4 x x x x
04:56:25 [1/1] xxxx xxx x x x x 4 x x x x
04:56:26 [1/1] xxxx xxx x x x x 4 x x x x
04:56:27 [1/1] xxxxx xxx x x x x 4 x x x x
04:56:28 [1/1] xxxxx xxx x x x x 5 x x x x
04:56:29 [1/1] xxxxx xxx x x x x 4 x x x x
04:56:30 [1/1] xxxxx xxx x x x x 4 x x x x
04:56:31 [1/1] xxxxx xxx x x x x 4 x x x x
04:56:32 [1/1] xxxxx xxx x x x x 3 x x x x
04:56:33 [1/1] xxxxx xxx x x x x 3 x x x x
04:56:34 [1/1] xxxxx xxx x x x x 4 x x x x
04:56:35 [1/1] xxxxx xxx x x x x 4 x x x x
04:56:36 [1/1] xxxxx xxx x x x x 4 x x x x
04:56:37 [1/1] xxxxx xxx x x x x 4 x x x x
04:56:38 [1/1] xxxxx xxx x x x xx 4 x x x x
04:56:39 [1/1] xxxxx xxx x x x x 4 x x x x
04:56:40 [1/1] xxxxx xxx x x x x 4 x x x x
04:56:41 [1/1] xxxxx xxx x x x x 4 x x x x
04:56:42 [1/1] xxxxx xxx x x x x 4 x x x x
04:56:43 [1/1] xxxxx xxx x x x x 4 x x x x
04:56:44 [1/1] xxxxx xxx x x x xx 4 x x x x
04:56:45 [1/1] xxxxx xxx x x x x 4 x x x x
04:56:46 [1/1] xxxxx xxx x x x x 4 x x x x
04:56:47 [1/1] xxxxx xxx x x x x 4 x x x x
04:56:48 [1/1] xxxxx xxx x x x x 4 x x x x
04:56:49 [1/1] xxxxx xxx x x x x 4 x x x x
04:56:50 [1/1] xxxxx xxx x x x x 4 x x x x
04:56:51 [1/1] xxxxx xxx x x x x 4 x x x x
04:56:52 [1/1] xxxxx xxx x x x x 4 x x x x
04:56:53 [1/1] xxxxx xxx x x x x 4 x x x x
04:56:54 [1/1] xxxxx xxx x x x x 4 x x x x
04:56:55 [1/1] xxxxx xxx x x x x 4 x x x x
04:56:56 [1/1] xxxxx xxx x x x xx 4 x x x x
04:56:57 [1/1] xxxxx xxx x x x x 4 x x x x
04:56:58 [1/1] xxxxx xxx x x x x 4 x x x x
04:56:59 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:00 [1/1] xxxxx xxx xx x x x 4 x x x x
04:57:01 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:02 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:03 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:04 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:05 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:06 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:07 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:08 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:09 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:10 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:11 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:12 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:13 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:14 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:15 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:16 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:17 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:18 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:19 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:20 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:21 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:22 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:23 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:24 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:25 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:26 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:27 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:28 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:29 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:30 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:31 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:32 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:33 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:34 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:35 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:36 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:37 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:38 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:39 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:40 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:41 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:42 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:43 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:44 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:45 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:46 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:47 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:48 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:49 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:50 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:51 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:52 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:53 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:54 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:55 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:56 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:57 [1/1] xxxxx xxx x x x x 4 x x x x
04:57:58 [1/1] xxxxx xxx x x x x 3 x x x x
04:57:59 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:00 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:01 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:02 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:03 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:04 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:05 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:06 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:07 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:08 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:09 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:10 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:11 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:12 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:13 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:14 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:15 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:16 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:17 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:18 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:19 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:20 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:21 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:22 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:23 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:24 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:25 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:26 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:27 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:28 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:29 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:30 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:31 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:32 [1/1] xxxxx xxx x x x x 3 x x x x
04:58:33 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:34 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:35 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:36 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:37 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:38 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:39 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:40 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:41 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:42 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:43 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:44 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:45 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:46 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:47 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:48 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:49 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:50 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:51 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:52 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:53 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:54 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:55 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:56 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:57 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:58 [1/1] xxxxx xxx x x x x 4 x x x x
04:58:59 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:00 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:01 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:02 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:03 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:04 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:05 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:06 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:07 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:08 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:09 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:10 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:11 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:12 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:13 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:14 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:15 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:16 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:17 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:18 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:19 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:20 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:21 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:22 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:23 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:24 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:25 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:26 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:27 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:28 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:29 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:30 [1/1] xxxxx xxx x x x x 5 x x x x
04:59:31 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:32 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:33 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:34 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:35 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:36 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:37 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:38 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:39 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:40 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:41 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:42 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:43 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:44 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:45 [1/1] xxxxx xxx x x x x 3 x x x x
04:59:46 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:47 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:48 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:49 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:50 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:51 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:52 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:53 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:54 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:55 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:56 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:57 [1/1] xxxxx xxx x x x x 4 x x x x
04:59:58 [1/1] xxxxx xxx x x x x 4 x x x x
05:00:00 [1/1] xxxxx xxx x x x x 4 x x x x
05:00:01 [1/1] xxxxx xxx x x x x 4 x x x x
05:00:02 [1/1] xxxxx xxx x x x x 4 x x x x
05:00:03 [1/1] xxxxx xxx x x x x 4 x x x x
05:00:04 [1/1] xxxxx xxx x x x x 4 x x x x
05:00:05 [1/1] xxxxx xxx x x x x 4 x x x x
05:00:06 [1/1] xxxxx xxx x x x x 4 x x x x
05:00:07 [1/1] xxxxx xxx x x x x 4 x x x x
05:00:08 [1/1] xxxxx xxx x x x x 4 x x x x
05:00:09 [1/1] xxxxx xxx x x x x 4 x x x x
05:00:10 [1/1] xxxxx xxx x x x x 4 x x x x
05:00:11 [1/1] xxxxx xxx x x x x 4 x x x x
05:00:12 [1/1] xxxxx xxx x x x x 4 x x x x
05:00:13 [1/1] xxxxx xxx x x x x 4 x x x x
05:00:14 [1/1] xxxxx xxx x x x x 4 x x x x
05:00:15 [1/1] xxxxx xxx x x x x 4 x x x x
05:00:16 [1/1] xxxxx xxx x x x x 5 x x x x
05:00:17 [1/1] xxxxx xxx x x x x 4 x x x x
05:00:18 [1/1] xxxxx xxx x x x x 4 x x x x
05:00:19 [1/1] xxxxx xxx xx x x x 4 x x x x
05:00:20 [1/1] xxxxx xxx x x x x 4 x x x x
05:00:21 [1/1] xxxxx xxx x x x x 4 x x x x
05:00:22 [1/1] xxxxx xxx x x x x 4 x x x x
05:00:23 [1/1] xxxxx xxx x x x x 4 x x x x
05:00:24 [1/1] xxxxx xxx x x x x 5 x x x x
05:00:25 [1/1] xxxxx xxx x x x x 5 x x x x
05:00:26 [1/1] xxxxx xxx x x x x 5 x x x x
05:00:27 [1/1] xxxxx xxx x x x x 4 x x x x
05:00:28 [1/1] xxxxx xxx x x x x 7 x x x x
05:00:29 [1/1] xxxxx xxx x x x x 4 x x x x
05:00:30 [1/1] xxxxx xxx x x x x 4 x x x x
05:00:31 [1/1] xxxxx xxx xx x x xx 5 xx x x x
05:00:32 [1/1] xxxxx xxx x x x x 4 x x x x
05:00:33 [1/1] xxxxx xxx x x x x 4 x x x x
05:00:34 [1/1] xxxxx xxx x x x x 4 xx x x x
05:00:35 [1/1] xxxxx xxx x x x x 4 x x x x
05:00:36 [1/1] xxxxx xxx x x x x 4 x x x x
05:00:37 [1/1] xxxxx xxx x x x x 4 x x x x
05:00:38 [1/1] xxxxx xxx x x x x 4 x x x x
05:00:39 [1/1] xxxxx xxx x x x x 4 x x x x
05:00:40 [1/1] xxxxx xxx x x x x 4 x x x x
05:00:41 [1/1] xxxxx xxx xx x x x 4 x x x x
05:00:42 [1/1] xxxxx xxx x x x x 4 x x x x
05:00:43 [1/1] xxxxx xxx x x x x 4 x x x x
05:00:44 [1/1] xxxxx xxx x x x x 4 x x x x
05:00:45 [1/1] xxxxx xxx x x x x 4 x x x x
05:00:46 [1/1] xxxxx xxx x x x x 5 x x x x
05:00:47 [1/1] xxxxx xxx xx x x x 7 x x x x
05:00:48 [1/1] xxxxx xxx x x x x 5 x x x x
05:00:49 [1/1] xxxxx xxx x x x x 4 x x x x
05:00:50 [1/1] xxxxx xxx x x x x 4 x x x x
05:00:51 [1/1] xxxxx xxx x x x x 4 x x x x
05:00:52 [1/1] xxxxx xxx x x x x 5 x x x x
05:00:53 [1/1] xxxxx xxx x x x x 9 x x x x
05:00:54 [1/1] xxxxx xxx x x x xx 5 x x x x
05:00:55 [1/1] xxxxx xxx x x x x 5 x x x x
05:00:56 [1/1] xxxxx xxx x x x x 5 x x x x
05:00:57 [1/1] xxxxx xxx x x x x 5 x x x x
05:00:58 [1/1] xxxxx xxx x x x x 4 x x x x
05:00:59 [1/1] xxxxx xxx x x x x 5 xx x x x
05:01:00 [1/1] xxxxx xxx x x x x 4 x x x x
05:01:01 [1/1] xxxxx xxx x x x x 4 x x x x
05:01:02 [1/1] xxxxx xxx x x x x 4 x x x x
05:01:03 [1/1] xxxxx xxx x x x x 5 x x x x
05:01:04 [1/1] xxxxx xxx x x x x 5 x x x x
05:01:05 [1/1] xxxxx xxx x x x x 5 x x x x
05:01:06 [1/1] xxxxx xxx x x x x 4 x x x x
05:01:07 [1/1] xxxxx xxx x x x x 5 x x x x
05:01:08 [1/1] xxxxx xxx x x x x 4 x x x x
05:01:09 [1/1] xxxxx xxx x x x x 4 x x x x
05:01:10 [1/1] xxxxx xxx x x x x 4 x x x x
05:01:11 [1/1] xxxxx xxx x x x x 5 x x x x
05:01:12 [1/1] xxxxx xxx x x x x 4 x x x x
05:01:13 [1/1] xxxxx xxx x x x x 5 x x x x
05:01:14 [1/1] xxxxx xx xxx x x xx 4 x x x x
05:01:15 [1/1] xxxxx xxx x x x x 4 x x x x
05:01:16 [1/1] xxxxx xxx x x x x 4 x x x x
05:01:17 [1/1] xxxxx xxx x x x x 4 x x x x
05:01:18 [1/1] xxxxx xxx x x x x 4 x x x x
05:01:19 [1/1] xxxxx xxx x x x x 4 x x x x
05:01:20 [1/1] xxxxx xxx x x x x 4 x x x x
05:01:21 [1/1] xxxxx xxx x x x x 4 x x x x
05:01:22 [1/1] xxxxx xxx x x x x 4 x x x x
05:01:23 [1/1] xxxxx xxx x x x x 4 x x x x
05:01:24 [1/1] xxxxx xxx x x x x 4 x x x x
05:01:25 [1/1] xxxxx xxx x x x x 4 x x x x
SQLブロック
許可リストから SQL削除
DBMS_SQL_FIREWALL.DELETE_ALLOWED_SQLを使用して、許可リストから SQL をひとつ削除します。
SQL>
SQL> BEGIN
2 DBMS_SQL_FIREWALL.DELETE_ALLOWED_SQL(
3 username => 'SOE',
4 allowed_sql_id => 10);
5 END;
6* /
PL/SQL procedure successfully completed.
SQL>
直後、Swingbench では エラーが発生し、PO はゼロになります。
The following error has occcured. Further occurences will be supressed but the error count will be incremented and recorded in the results file
java.sql.SQLException: ORA-47605: SQL Firewall violation
https://docs.oracle.com/error-help/db/ora-47605/
05:01:26 [1/1] xxxxx xxx x x x x 4 x x x x
05:01:27 [1/1] xxxxx xxx x x x x 0 x x x x
05:01:28 [1/1] xxxxx xxx x x x x 0 x x x x
05:01:29 [1/1] xxxxx xxx x x x x 0 x x x x
05:01:30 [1/1] xxxxx xxx x x x x 0 x x x x
05:01:31 [1/1] xxxxx xxx x x x x 0 x x x x
05:01:32 [1/1] xxxxx xxx x x x x 0 x x x x
05:01:33 [1/1] xxxxx xxx x x x x 0 x x x x
05:01:34 [1/1] xxxxx xxx x x x x 0 x x x x
05:01:35 [1/1] xxxxx xxx x x x x 0 x x x x
05:01:36 [1/1] xxxxx xxx x x x x 0 x x x x
05:01:37 [1/1] xxxxx xxx x x x x 0 x x x x
05:01:38 [1/1] xxxxx xxx x x x xx 0 x x x x
05:01:39 [1/1] xxxxx xxx x x x x 0 x x x x
05:01:40 [1/1] xxxxx xxx x x x x 0 x x x x
05:01:41 [1/1] xxxxx xxx x x x x 0 x x x x
05:01:42 [1/1] xxxxx xx x x x xx 0 x x x x
05:01:43 [1/1] xxxxx xxx x x x x 0 x x x x
05:01:44 [1/1] xxxxx xxx x x x x 0 x x x x
05:01:45 [1/1] xxxxx xxx x x x x 0 x x x x
05:01:46 [1/1] xxxxx xxx x x x x 0 x x x x
05:01:47 [1/1] xxxxx xxx x x x x 0 x x x x
05:01:48 [1/1] xxxxx xxx x x x x 0 x x x x
05:01:49 [1/1] xxxxx xxx x x x x 0 x x x x
05:01:50 [1/1] xxxxx xxx x x x x 0 x x x x
05:01:51 [1/1] xxxxx xxx x x x x 0 x x x x
05:01:52 [1/1] xxxxx xxx x x x x 0 x x x x
05:01:53 [1/1] xxxxx xxx x x x x 0 x x x x
05:01:54 [1/1] xxxxx xxx x x x xx 0 x x x x
05:01:55 [1/1] xxxxx xxx x x x x 0 x x x x
05:01:56 [1/1] xxxxx xxx x x x xx 0 x x x x
05:01:57 [1/1] xxxxx xxx x x x x 0 x x x x
05:01:58 [1/1] xxxxx xxx x x x x 0 x x x x
05:01:59 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:00 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:01 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:02 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:03 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:04 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:05 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:06 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:07 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:08 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:09 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:10 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:11 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:12 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:13 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:14 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:15 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:16 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:17 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:18 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:19 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:20 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:21 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:22 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:23 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:24 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:25 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:26 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:27 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:28 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:29 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:30 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:31 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:32 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:33 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:34 [1/1] xxxxx xxx xx x x x 0 x x x x
05:02:35 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:36 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:37 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:38 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:39 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:40 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:41 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:42 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:43 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:44 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:45 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:46 [1/1] xxxxx xxx x x x xx 0 x x x x
05:02:47 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:48 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:49 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:50 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:51 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:52 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:53 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:54 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:55 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:56 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:57 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:58 [1/1] xxxxx xxx x x x x 0 x x x x
05:02:59 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:00 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:01 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:02 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:03 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:04 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:05 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:06 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:07 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:08 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:09 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:10 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:11 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:12 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:13 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:14 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:15 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:16 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:17 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:18 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:19 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:20 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:21 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:22 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:23 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:24 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:25 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:26 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:27 [1/1] xxxxx xxx x xx x x 0 x x x x
05:03:28 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:29 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:30 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:31 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:32 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:33 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:34 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:35 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:36 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:37 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:38 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:39 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:40 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:41 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:42 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:43 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:44 [1/1] xxxxx xxx xx x x xx 0 x x x x
05:03:45 [1/1] xxxxx xxx xx x x xx 0 x x x x
05:03:46 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:47 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:48 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:49 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:50 [1/1] xxxxx xx x x x x 0 x x x x
05:03:51 [1/1] xxxxx xxx x x x xx 0 x x x x
05:03:52 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:53 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:54 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:55 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:56 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:57 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:58 [1/1] xxxxx xxx x x x x 0 x x x x
05:03:59 [1/1] xxxxx xxx x x x x 0 x x x x
05:04:00 [1/1] xxxxx xxx x x x x 0 x x x x
05:04:01 [1/1] xxxxx xxx x x x xx 0 x x x x
05:04:02 [1/1] xxxxx xxx x x x x 0 x x x x
05:04:03 [1/1] xxxxx xxx x x x x 0 x x x x
05:04:04 [1/1] xxxxx xxx x x x x 0 x x x x
05:04:05 [1/1] xxxxx xxx x x x x 0 x x x x
05:04:06 [1/1] xxxxx xxx x x x x 0 x x x x
05:04:07 [1/1] xxxxx xxx x x x x 0 x x x x
05:04:08 [1/1] xxxxx xxx x x x x 0 x x x x
05:04:09 [1/1] xxxxx xxx x x x x 0 x x x x
05:04:10 [1/1] xxxxx xxx x x x x 0 x x x x
05:04:11 [1/1] xxxxx xxx x x x x 0 x x x x
05:04:12 [1/1] xxxxx xxx x x x x 0 x x x x
05:04:13 [1/1] xxxxx xxx x x x x 0 x x x x
05:04:14 [1/1] xxxxx xxx x x x x 0 x x x x
05:04:15 [1/1] xxxxx xxx x x x x 0 x x x x
05:04:16 [1/1] xxxxx xxx x x x x 0 x x x x
05:04:17 [1/1] xxxxx xxx x x x x 0 x x x x
05:04:18 [1/1] xxxxx xxx x x x x 0 x x x x
05:04:19 [1/1] xxxxx xxx x x x x 0 x x x x
05:04:20 [1/1] xxxxx xxx x x x x 0 x x x x
05:04:21 [1/1] xxxxx xxx x x x x 0 x x x x
05:04:22 [1/1] xxxxx xxx x x x x 0 x x x x
05:04:23 [1/1] xxxxx xxx x x x x 0 x x x x
05:04:24 [1/1] xxxxx xxx x x x x 0 x x x x
05:04:25 [1/1] xxxxx xxx x x x x 0 x x x x
05:04:26 [1/1] xxxxx xxx x x x x 0 x x x x
05:04:27 [1/1] xxxxx xxx x x x x 0 x x x x
05:04:28 [1/1] xxxxx xxx x x x x 0 x x x x
05:04:29 [1/1] xxxxx xxx xx x x x 0 x x x x
05:04:30 [1/1] xxxxx xxx x x x x 0 x x x x
05:04:31 [1/1] xxxxx xxx x x x x 0 x x x x
DBA_SQL_FIREWALL_ALLOWED_SQL を参照すると、ブロックされた SQL が確認できます。
Process Orders がブロックされていることがわかります。
SQL>
SQL>
SQL> select * from DBA_SQL_FIREWALL_ALLOWED_SQL;
USERNAME ALLOWED_SQL_ID SQL_SIGNATURE SQL_TEXT ACCESSED_OBJECTS CURRENT_USER TOP_LEVEL VERSION
___________ _________________ ___________________________________________________________________ ___________________________________________________________________________ ________________________________ _______________ ____________ __________
SOE 3 8B15698920B663C4E9916B600DADF877C0E7F01B88774F09C39088F62A82CC69 SELECT :"SYS_B_0" FROM USER_TABLES WHERE TABLE_NAME=:"SYS_B_1" "SYS"."USER_TABLES" SOE Y 1
SOE 5 A9EDAECAC2F1D8076B3E9C7B6B5B6CB6B4B62FD43A0D867D3D522C103AC3E455 BEGIN :1 :=ORDERENTRY.BROWSEPRODUCTS (:2,:3,:4); END; "SOE"."ORDERENTRY" SOE Y 1
SOE 9 9D6E8DE6D0085F2702F07AAFF0E14DE5AE89490772112DD20F83A2E61F4E7CDE BEGIN :1 :=ORDERENTRY.BROWSEANDUPDATEORDERS (:2,:3,:4); END; "SOE"."ORDERENTRY" SOE Y 1
SOE 1 C6124DA5BD26E22D3E440C96B3C80BFE548ECF02472BE543141CA64918373AEB BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO (?); END; "SYS"."DBMS_APPLICATION_INFO" SOE Y 1
SOE 2 B66E03A01CA6EE0E68FD63BB5129C0A06450F830EBBBEB44C964BAC005B6F591 BEGIN ORDERENTRY.SETPLSQLCOMMIT (:1); END; "SOE"."ORDERENTRY" SOE Y 1
SOE 8 CADD8AF0C261DE99B260EC71AA41F3DEA94BC0BD8AA4B5F9E40FF1B40828DA2C BEGIN :1 :=ORDERENTRY.NEWCUSTOMER (:2,:3,:4,:5,:6,:7,:8,:9,:10); END; "SOE"."ORDERENTRY" SOE Y 1
SOE 6 3240800754A97F3AEDCB1B8C373DB2484C4F2FDF969BECDBAC957A1813BAB556 BEGIN :1 :=ORDERENTRY.UPDATECUSTOMERDETAILS (:2,:3,:4,:5,:6,:7,:8); END; "SOE"."ORDERENTRY" SOE Y 1
SOE 7 AA22947E9B37404FF686E8B95E62376458F3440EA8BBA5BE9E2272B00268C303 BEGIN :1 :=ORDERENTRY.NEWORDER (:2,:3,:4); END; "SOE"."ORDERENTRY" SOE Y 1
SOE 4 79CC743EE363521BA20A1B9791F763511216D5399943F49551FC36BBCF17D57F SELECT METADATA_KEY,METADATA_VALUE FROM ORDERENTRY_METADATA "SOE"."ORDERENTRY_METADATA" SOE Y 1
9 rows selected.
SQL>
SQL>
SQL> select * from DBA_SQL_FIREWALL_VIOLATIONS;
USERNAME COMMAND_TYPE SQL_SIGNATURE SQL_TEXT ACCESSED_OBJECTS CURRENT_USER TOP_LEVEL IP_ADDRESS CLIENT_PROGRAM OS_USER CAUSE FIREWALL_ACTION OCCURRED_AT
___________ _______________ ___________________________________________________________________ _______________________________________________________ _____________________ _______________ ____________ ______________ ___________________ __________ ________________ __________________ ______________________________________
SOE EXECUTE 5C952C6E4EED095251FD98FD6F13F074EAFBB4614AB8D4A2E1B78EE7A06BC600 BEGIN :1 :=ORDERENTRY.PROCESSORDERS (:2,:3,:4); END; "SOE"."ORDERENTRY" SOE Y xxx.xxx.xxx.xxx JDBC Thin Client opc SQL violation Blocked 30-OCT-26 05.01.33.677751000 AM GMT
SOE EXECUTE 5C952C6E4EED095251FD98FD6F13F074EAFBB4614AB8D4A2E1B78EE7A06BC600 BEGIN :1 :=ORDERENTRY.PROCESSORDERS (:2,:3,:4); END; "SOE"."ORDERENTRY" SOE Y xxx.xxx.xxx.xxx JDBC Thin Client opc SQL violation Blocked 30-OCT-26 05.01.33.715453000 AM GMT
SOE EXECUTE 5C952C6E4EED095251FD98FD6F13F074EAFBB4614AB8D4A2E1B78EE7A06BC600 BEGIN :1 :=ORDERENTRY.PROCESSORDERS (:2,:3,:4); END; "SOE"."ORDERENTRY" SOE Y xxx.xxx.xxx.xxx JDBC Thin Client opc SQL violation Blocked 30-OCT-26 05.01.33.804028000 AM GMT
SOE EXECUTE 5C952C6E4EED095251FD98FD6F13F074EAFBB4614AB8D4A2E1B78EE7A06BC600 BEGIN :1 :=ORDERENTRY.PROCESSORDERS (:2,:3,:4); END; "SOE"."ORDERENTRY" SOE Y xxx.xxx.xxx.xxx JDBC Thin Client opc SQL violation Blocked 30-OCT-26 05.01.33.941631000 AM GMT
SOE EXECUTE 5C952C6E4EED095251FD98FD6F13F074EAFBB4614AB8D4A2E1B78EE7A06BC600 BEGIN :1 :=ORDERENTRY.PROCESSORDERS (:2,:3,:4); END; "SOE"."ORDERENTRY" SOE Y xxx.xxx.xxx.xxx JDBC Thin Client opc SQL violation Blocked 30-OCT-26 05.01.33.975599000 AM GMT
(snip)
SOE EXECUTE 5C952C6E4EED095251FD98FD6F13F074EAFBB4614AB8D4A2E1B78EE7A06BC600 BEGIN :1 :=ORDERENTRY.PROCESSORDERS (:2,:3,:4); END; "SOE"."ORDERENTRY" SOE Y xxx.xxx.xxx.xxx JDBC Thin Client opc SQL violation Blocked 30-OCT-26 05.01.33.248702000 AM GMT
SOE EXECUTE 5C952C6E4EED095251FD98FD6F13F074EAFBB4614AB8D4A2E1B78EE7A06BC600 BEGIN :1 :=ORDERENTRY.PROCESSORDERS (:2,:3,:4); END; "SOE"."ORDERENTRY" SOE Y xxx.xxx.xxx.xxx JDBC Thin Client opc SQL violation Blocked 30-OCT-26 05.01.33.484237000 AM GMT
SOE EXECUTE 5C952C6E4EED095251FD98FD6F13F074EAFBB4614AB8D4A2E1B78EE7A06BC600 BEGIN :1 :=ORDERENTRY.PROCESSORDERS (:2,:3,:4); END; "SOE"."ORDERENTRY" SOE Y xxx.xxx.xxx.xxx JDBC Thin Client opc SQL violation Blocked 30-OCT-26 05.01.33.609556000 AM GMT
SOE EXECUTE 5C952C6E4EED095251FD98FD6F13F074EAFBB4614AB8D4A2E1B78EE7A06BC600 BEGIN :1 :=ORDERENTRY.PROCESSORDERS (:2,:3,:4); END; "SOE"."ORDERENTRY" SOE Y xxx.xxx.xxx.xxx JDBC Thin Client opc SQL violation Blocked 30-OCT-26 05.01.33.613624000 AM GMT
SOE EXECUTE 5C952C6E4EED095251FD98FD6F13F074EAFBB4614AB8D4A2E1B78EE7A06BC600 BEGIN :1 :=ORDERENTRY.PROCESSORDERS (:2,:3,:4); END; "SOE"."ORDERENTRY" SOE Y xxx.xxx.xxx.xxx JDBC Thin Client opc SQL violation Blocked 30-OCT-26 05.01.33.638553000 AM GMT
547 rows selected.
SQL>
SQL>
許可リスト追加
DBMS_SQL_FIREWALL.APPEND_ALLOW_LISTで許可リストを追加します。
今回追加したいのは現在ブロックされている SQL なので、sourceには DBMS_SQL_FIREWALL.VIOLATION_LOG を指定します。
SQL>
SQL> BEGIN
2 DBMS_SQL_FIREWALL.APPEND_ALLOW_LIST(
3 username => 'SOE',
4 source => DBMS_SQL_FIREWALL.VIOLATION_LOG);
5 END;
6* /
PL/SQL procedure successfully completed.
SQL>
SQL>
SQL> select * from DBA_SQL_FIREWALL_ALLOWED_SQL;
USERNAME ALLOWED_SQL_ID SQL_SIGNATURE SQL_TEXT ACCESSED_OBJECTS CURRENT_USER TOP_LEVEL VERSION
___________ _________________ ___________________________________________________________________ ___________________________________________________________________________ ________________________________ _______________ ____________ __________
SOE 3 8B15698920B663C4E9916B600DADF877C0E7F01B88774F09C39088F62A82CC69 SELECT :"SYS_B_0" FROM USER_TABLES WHERE TABLE_NAME=:"SYS_B_1" "SYS"."USER_TABLES" SOE Y 1
SOE 5 A9EDAECAC2F1D8076B3E9C7B6B5B6CB6B4B62FD43A0D867D3D522C103AC3E455 BEGIN :1 :=ORDERENTRY.BROWSEPRODUCTS (:2,:3,:4); END; "SOE"."ORDERENTRY" SOE Y 1
SOE 9 9D6E8DE6D0085F2702F07AAFF0E14DE5AE89490772112DD20F83A2E61F4E7CDE BEGIN :1 :=ORDERENTRY.BROWSEANDUPDATEORDERS (:2,:3,:4); END; "SOE"."ORDERENTRY" SOE Y 1
SOE 1 C6124DA5BD26E22D3E440C96B3C80BFE548ECF02472BE543141CA64918373AEB BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO (?); END; "SYS"."DBMS_APPLICATION_INFO" SOE Y 1
SOE 2 B66E03A01CA6EE0E68FD63BB5129C0A06450F830EBBBEB44C964BAC005B6F591 BEGIN ORDERENTRY.SETPLSQLCOMMIT (:1); END; "SOE"."ORDERENTRY" SOE Y 1
SOE 8 CADD8AF0C261DE99B260EC71AA41F3DEA94BC0BD8AA4B5F9E40FF1B40828DA2C BEGIN :1 :=ORDERENTRY.NEWCUSTOMER (:2,:3,:4,:5,:6,:7,:8,:9,:10); END; "SOE"."ORDERENTRY" SOE Y 1
SOE 6 3240800754A97F3AEDCB1B8C373DB2484C4F2FDF969BECDBAC957A1813BAB556 BEGIN :1 :=ORDERENTRY.UPDATECUSTOMERDETAILS (:2,:3,:4,:5,:6,:7,:8); END; "SOE"."ORDERENTRY" SOE Y 1
SOE 7 AA22947E9B37404FF686E8B95E62376458F3440EA8BBA5BE9E2272B00268C303 BEGIN :1 :=ORDERENTRY.NEWORDER (:2,:3,:4); END; "SOE"."ORDERENTRY" SOE Y 1
SOE 10 5C952C6E4EED095251FD98FD6F13F074EAFBB4614AB8D4A2E1B78EE7A06BC600 BEGIN :1 :=ORDERENTRY.PROCESSORDERS (:2,:3,:4); END; "SOE"."ORDERENTRY" SOE Y 2
SOE 4 79CC743EE363521BA20A1B9791F763511216D5399943F49551FC36BBCF17D57F SELECT METADATA_KEY,METADATA_VALUE FROM ORDERENTRY_METADATA "SOE"."ORDERENTRY_METADATA" SOE Y 1
10 rows selected.
SQL>
SQL>
SQL>
SQL>
Swingbench のログから、Process Orders が実行できていることがわかります。
05:04:32 [1/1] xxxxx xxx x x x x 5 x x x x
05:04:33 [1/1] xxxxx xxx x x x x 4 x x x x
05:04:34 [1/1] xxxxx xxx x x x x 4 x x x x
05:04:35 [1/1] xxxxx xxx x x x x 4 x x x x
05:04:36 [1/1] xxxxx xxx x x x x 4 x x x x
05:04:37 [1/1] xxxxx xxx x x x x 4 x x x x
05:04:38 [1/1] xxxxx xxx x x x x 4 x x x x
05:04:39 [1/1] xxxxx xxx x x x x 4 x x x x
05:04:40 [1/1] xxxxx xxx x x x x 4 x x x x
05:04:41 [1/1] xxxxx xxx x x x x 4 x x x x
05:04:42 [1/1] xxxxx xxx x x x x 4 x x x x
05:04:43 [1/1] xxxxx xxx x x x x 4 x x x x
05:04:44 [1/1] xxxxx xxx x x x x 4 x x x x
05:04:45 [1/1] xxxxx xxx x x x x 4 x x x x
05:04:46 [1/1] xxxxx xxx x x x x 4 x x x x
05:04:47 [1/1] xxxxx xxx x x x x 4 x x x x
05:04:48 [1/1] xxxxx xxx x x x x 4 x x x x
05:04:49 [1/1] xxxxx xxx x x x x 4 x x x x
05:04:50 [1/1] xxxxx xxx x x x x 4 x x x x
05:04:51 [1/1] xxxxx xxx x x x x 4 x x x x
05:04:52 [1/1] xxxxx xxx x x x x 4 x x x x
05:04:53 [1/1] xxxxx xxx x x x x 4 x x x x
05:04:54 [1/1] xxxxx xxx x x x x 7 x x x x
05:04:55 [1/1] xxxxx xxx x x x x 4 x x x x
05:04:56 [1/1] xxxxx xxx x x x x 4 x x x x
05:04:57 [1/1] xxxxx xxx x x x x 4 x x x x
05:04:58 [1/1] xxxxx xxx x x x x 4 x x x x
05:04:59 [1/1] xxxxx xxx x x x x 4 x x x x
05:05:00 [1/1] xxxxx xxx x x x x 4 x x x x
05:05:01 [1/1] xxxxx xxx x x x x 4 x x x x
05:05:02 [1/1] xxxxx xxx x x x x 4 x x x x
05:05:03 [1/1] xxxxx xxx x x x x 4 x x x x
05:05:04 [1/1] xxxxx xxx x x x x 4 x x x x
05:05:05 [1/1] xxxxx xxx x x x x 4 x x x x
05:05:06 [1/1] xxxxx xxx x x x x 4 x x x x
05:05:07 [1/1] xxxxx xxx x x x x 4 x x x x
05:05:08 [1/1] xxxxx xxx x x x x 4 x x x x
05:05:09 [1/1] xxxxx xxx x x x x 4 x x x x
05:05:10 [1/1] xxxxx xxx x x x x 4 x x x x
05:05:11 [1/1] xxxxx xxx x x x x 4 x x x x
05:05:12 [1/1] xxxxx xxx x x x x 4 x x x x
05:05:13 [1/1] xxxxx xxx x x x x 4 x x x x
05:05:14 [1/1] xxxxx xxx x x x x 4 x x x x
05:05:15 [1/1] xxxxx xxx x x x x 4 x x x x
05:05:16 [1/1] xxxxx xxx x x x x 4 x x x x
05:05:17 [1/1] xxxxx xxx x x x x 4 x x x x