Skip to content

Commit 9ed6e00

Browse files
committed
Script update
1 parent 2cd41b2 commit 9ed6e00

File tree

1 file changed

+1
-4
lines changed

1 file changed

+1
-4
lines changed

Ch06_SQLInjection/src/main/resources/customerDB.script

Lines changed: 1 addition & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -3,20 +3,17 @@ SET DATABASE GC 0
33
SET DATABASE DEFAULT RESULT MEMORY ROWS 0
44
SET DATABASE EVENT LOG LEVEL 0
55
SET DATABASE SQL NAMES FALSE
6-
SET DATABASE SQL REGULAR NAMES TRUE
76
SET DATABASE SQL REFERENCES FALSE
87
SET DATABASE SQL SIZE TRUE
98
SET DATABASE SQL TYPES FALSE
109
SET DATABASE SQL TDC DELETE TRUE
1110
SET DATABASE SQL TDC UPDATE TRUE
1211
SET DATABASE SQL TRANSLATE TTI TYPES TRUE
1312
SET DATABASE SQL CONCAT NULLS TRUE
14-
SET DATABASE SQL NULLS FIRST TRUE
1513
SET DATABASE SQL UNIQUE NULLS TRUE
1614
SET DATABASE SQL CONVERT TRUNCATE TRUE
1715
SET DATABASE SQL AVG SCALE 0
1816
SET DATABASE SQL DOUBLE NAN TRUE
19-
SET DATABASE SQL LONGVAR IS LOB FALSE
2017
SET DATABASE TRANSACTION CONTROL LOCKS
2118
SET DATABASE DEFAULT ISOLATION LEVEL READ COMMITTED
2219
SET DATABASE TRANSACTION ROLLBACK ON CONFLICT TRUE
@@ -39,11 +36,11 @@ SET SCHEMA PUBLIC
3936
CREATE MEMORY TABLE PUBLIC.CUSTOMER(CUST_ID INTEGER,NAME VARCHAR(45),STATUS VARCHAR(45),ORDER_LIMIT INTEGER)
4037
ALTER SEQUENCE SYSTEM_LOBS.LOB_ID RESTART WITH 1
4138
SET DATABASE DEFAULT INITIAL SCHEMA PUBLIC
39+
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.SQL_IDENTIFIER TO PUBLIC
4240
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.YES_OR_NO TO PUBLIC
4341
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.TIME_STAMP TO PUBLIC
4442
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.CARDINAL_NUMBER TO PUBLIC
4543
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.CHARACTER_DATA TO PUBLIC
46-
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.SQL_IDENTIFIER TO PUBLIC
4744
GRANT DBA TO SA
4845
SET SCHEMA SYSTEM_LOBS
4946
INSERT INTO BLOCKS VALUES(0,2147483647,0)

0 commit comments

Comments
 (0)