Debian Codegraph @

mysql-test/suite/auth_sec/t/atomic_routine_grants.test

raw
1 --source include/have_log_bin.inc
2 --source include/save_binlog_position.inc
3
4 # Save the initial number of concurrent sessions
5 --source include/count_sessions.inc
6
7 --echo # ----------------------------------------------------------------------
8
9 --echo # Begin : Tests for GRANT : Routine grants
10
11 CREATE USER userX, userY, userZ;
12 CREATE DATABASE db1;
13 DELIMITER ||;
14 CREATE PROCEDURE db1.proc1()
15 BEGIN
16 SELECT 1234;
17 END ||
18 DELIMITER ;||
19 --source include/save_binlog_position.inc
20
21 --echo # Case 1 : Valid grants
22
23 GRANT EXECUTE ON PROCEDURE db1.proc1 TO userX, userY, userZ;
24
25 --echo # Must show new grant
26 SHOW GRANTS FOR userX;
27 SHOW GRANTS FOR userY;
28 SHOW GRANTS FOR userZ;
29
30 --let $event= !Q(GRANT EXECUTE ON PROCEDURE.*db1.*proc1.*TO.*userX.*userY.*userZ.*)
31 --source ../include/auth_sec_assert_binlog_events.inc
32 --source include/save_binlog_position.inc
33
34 --echo # Case 6 : Create new user with an account without CREATE USER privilege
35
36 CREATE USER userA, userB;
37 GRANT EXECUTE ON PROCEDURE db1.proc1 to userX WITH GRANT OPTION;
38
39 SHOW GRANTS FOR userY;
40 SHOW GRANTS FOR userZ;
41 SHOW GRANTS FOR userA;
42 SHOW GRANTS FOR userB;
43
44 --source include/save_binlog_position.inc
45 connect(conn_userX, localhost, userX,,,,,);
46 connection conn_userX;
47
48 --echo # should succeed
49 GRANT EXECUTE ON PROCEDURE db1.proc1 TO userY, userZ;
50
51 --echo # should fail
52 --error ER_CANT_CREATE_USER_WITH_GRANT
53 GRANT EXECUTE ON PROCEDURE db1.proc1 TO userA, userB, userC;
54
55 connection default;
56 disconnect conn_userX;
57
58 --echo # Must show updated grants
59
60 SHOW GRANTS FOR userY;
61 SHOW GRANTS FOR userZ;
62
63 --echo # Must not have any change
64 SHOW GRANTS FOR userA;
65 SHOW GRANTS FOR userB;
66
67 --let $event= !Q(GRANT EXECUTE ON PROCEDURE.*db1.*proc1.*TO.*userY.*userZ.*)
68 --source ../include/auth_sec_assert_binlog_events.inc
69
70 DROP USER userX, userY, userZ, userA, userB;
71 DROP PROCEDURE db1.proc1;
72 DROP DATABASE db1;
73 --source include/save_binlog_position.inc
74
75 --echo # End : Tests for GRANT : Routine grants
76
77 --echo # ----------------------------------------------------------------------
78
79 # Wait till we reached the initial number of concurrent sessions
80 --source include/wait_until_count_sessions.inc