Debian Codegraph @

mysql-test/suite/perfschema/t/read_only.test

raw
1 # Tests for PERFORMANCE_SCHEMA
2 #
3 # Check that
4 # - a regular user can not update setup_ tables under --read-only
5 # - a user with SUPER privileges can
6
7 --source include/not_embedded.inc
8 --source include/have_perfschema.inc
9 --enable_connect_log
10
11 use performance_schema;
12
13 set @start_read_only= @@global.read_only;
14
15 create user pfsuser@localhost;
16 grant SELECT, UPDATE on performance_schema.* to pfsuser@localhost;
17 flush privileges;
18
19 connect (con1, localhost, pfsuser, ,"*NO-ONE*");
20
21 connection default;
22
23 set global read_only=0;
24
25 connection con1;
26
27 select @@global.read_only;
28 show grants;
29 --disable_result_log
30 --echo # Update on perf_schema is allowed in read_only mode.
31 select * from performance_schema.setup_instruments;
32 update performance_schema.setup_instruments set enabled='NO';
33 update performance_schema.setup_instruments set enabled='YES';
34 --enable_result_log
35
36 connection default;
37
38 set global read_only=1;
39
40 connection con1;
41
42 select @@global.read_only;
43 show grants;
44 --disable_result_log
45 select * from performance_schema.setup_instruments;
46 --error ER_OPTION_PREVENTS_STATEMENT
47 update performance_schema.setup_instruments set enabled='NO';
48 --error ER_OPTION_PREVENTS_STATEMENT
49 update performance_schema.setup_instruments set enabled='YES';
50 --enable_result_log
51
52 connection default;
53
54 grant READ_ONLY ADMIN on *.* to pfsuser@localhost;
55 flush privileges;
56
57 disconnect con1;
58 connect (con1, localhost, pfsuser, ,"*NO-ONE*");
59
60 select @@global.read_only;
61 show grants;
62 --disable_result_log
63 select * from performance_schema.setup_instruments;
64 update performance_schema.setup_instruments set enabled='NO';
65 update performance_schema.setup_instruments set enabled='YES';
66 --enable_result_log
67
68 disconnect con1;
69 --source include/wait_until_disconnected.inc
70
71 connection default;
72
73 set global read_only= @start_read_only;
74
75 drop user pfsuser@localhost;
76 flush privileges;
77