1
DROP TABLE IF EXISTS b;
2
CREATE TABLE b (i int, PRIMARY KEY (i));
3
INSERT INTO b VALUES (1);
4
INSERT INTO b VALUES (2);
5
INSERT INTO b VALUES (3);
6
INSERT INTO b VALUES (4);
7
INSERT INTO b VALUES (5);
8
INSERT INTO b VALUES (6);
9
INSERT INTO b VALUES (7);
10
INSERT INTO b VALUES (8);
11
INSERT INTO b VALUES (9);
12
INSERT INTO b VALUES (10);
13
INSERT INTO b VALUES (11);
14
INSERT INTO b VALUES (12);
15
INSERT INTO b VALUES (13);
16
INSERT INTO b VALUES (14);
17
SELECT USER, COUNT_SELECT, COUNT_DELETE, COUNT_UPDATE, COUNT_INSERT, COUNT_ROLLBACK, COUNT_COMMIT, COUNT_CREATE, COUNT_ALTER, COUNT_DROP, COUNT_ADMIN FROM DATA_DICTIONARY.CURRENT_SQL_COMMANDS;
18
USER COUNT_SELECT COUNT_DELETE COUNT_UPDATE COUNT_INSERT COUNT_ROLLBACK COUNT_COMMIT COUNT_CREATE COUNT_ALTER COUNT_DROP COUNT_ADMIN
19
drizzle 0 0 0 1 0 0 0 0 0 0
20
drizzle_test 0 0 0 1 0 0 0 0 0 0
21
root 0 0 0 0 0 0 0 0 1 0
22
drizzle 0 0 0 1 0 0 0 0 0 0
23
root 0 0 0 1 0 0 1 0 0 0
24
drizzle 0 0 0 1 0 0 0 0 0 0
25
drizzle 0 0 0 1 0 0 0 0 0 0
26
drizzle 0 0 0 1 0 0 0 0 0 0
27
drizzle 0 0 0 1 0 0 0 0 0 0