14
14
INSERT INTO b VALUES (12);
15
15
INSERT INTO b VALUES (13);
16
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;
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 WHERE USER != "root";
18
18
USER COUNT_SELECT COUNT_DELETE COUNT_UPDATE COUNT_INSERT COUNT_ROLLBACK COUNT_COMMIT COUNT_CREATE COUNT_ALTER COUNT_DROP COUNT_ADMIN
19
19
drizzle 0 0 0 1 0 0 0 0 0 0
20
drizzle 0 0 0 1 0 0 0 0 0 0
21
drizzle 0 0 0 1 0 0 0 0 0 0
22
drizzle 0 0 0 1 0 0 0 0 0 0
23
drizzle 0 0 0 1 0 0 0 0 0 0
24
drizzle 0 0 0 1 0 0 0 0 0 0
20
25
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
29
27
show global status;
30
28
Variable_name Value