Debian Codegraph @

mysql-test/suite/sys_vars/t/read_only_grant.test

raw
1 --source include/not_embedded.inc
2
3 --echo #
4 --echo # MDEV-21960 Bind READ_ONLY ADMIN to @@read_only
5 --echo #
6
7 --echo # Test that "SET read_only" is not allowed without READ_ONLY ADMIN
8
9 CREATE USER user1@localhost;
10 GRANT ALL PRIVILEGES ON *.* TO user1@localhost;
11 REVOKE READ_ONLY ADMIN ON *.* FROM user1@localhost;
12 --connect(user1,localhost,user1,,)
13 --connection user1
14 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
15 SET GLOBAL read_only=0;
16 --error ER_GLOBAL_VARIABLE
17 SET read_only=0;
18 --error ER_GLOBAL_VARIABLE
19 SET SESSION read_only=0;
20 --disconnect user1
21 --connection default
22 DROP USER user1@localhost;
23
24 --echo # Test that "SET read_only" is allowed with READ_ONLY ADMIN
25
26 CREATE USER user1@localhost;
27 GRANT READ_ONLY ADMIN ON *.* TO user1@localhost;
28 --connect(user1,localhost,user1,,)
29 --connection user1
30 SET GLOBAL read_only=0;
31 --error ER_GLOBAL_VARIABLE
32 SET read_only=0;
33 --error ER_GLOBAL_VARIABLE
34 SET SESSION read_only=0;
35 --disconnect user1
36 --connection default
37 DROP USER user1@localhost;
38
39 --echo #
40 --echo # MDEV-29632 SUPER users created before 10.11 should retain READ_ONLY ADMIN privilege upon upgrade
41 --echo #
42 insert mysql.global_priv values ('bar', 'foo', '{"access":32768,"version_id":101000,"plugin":"mysql_native_password","authentication_string":""}');
43 flush privileges;
44 show grants for foo@bar;
45 drop user foo@bar;