Debian Codegraph @

mysql-test/suite/auth_sec/include/acl_tables_locking_tests_helper.inc

raw
1 #
2 # Usage:
3 # --let $SQL=<SQL statement>
4 # --let $EXPECT_ERROR = 0 | 1
5 # --let $EXPECTED_ERROR_NUMBER = <error_number>
6 # --source acl_tables_locking_tests_helper.inc
7 #
8
9 --enable_connect_log
10
11 CREATE USER u1 IDENTIFIED BY 'abcd';
12 GRANT SELECT, UPDATE ON *.* TO u1;
13
14 --connect(conn_u1, localhost, u1, abcd,,,)
15 SET @@autocommit=0;
16 --connect(conn_root_1, localhost, root,,,,)
17 SET @@lock_wait_timeout=1;
18
19 --connection conn_u1
20 --eval $SQL
21
22 --connection conn_root_1
23 if ($EXPECT_ERROR) {
24 --error $EXPECTED_ERROR_NUMBER
25 CREATE USER u2;
26 --error $EXPECTED_ERROR_NUMBER
27 CREATE ROLE r1;
28 --error $EXPECTED_ERROR_NUMBER
29 GRANT SELECT ON *.* TO r1;
30 --error $EXPECTED_ERROR_NUMBER
31 GRANT r1 TO u2;
32 --error $EXPECTED_ERROR_NUMBER
33 SET DEFAULT ROLE r1 TO u2;
34 --error $EXPECTED_ERROR_NUMBER
35 ALTER USER u2 IDENTIFIED BY 'abcd';
36 --error $EXPECTED_ERROR_NUMBER
37 RENAME USER u2 TO u3;
38 --error $EXPECTED_ERROR_NUMBER
39 SET PASSWORD FOR u2 = 'abcd';
40 --error $EXPECTED_ERROR_NUMBER
41 REVOKE r1 FROM u2;
42 --error $EXPECTED_ERROR_NUMBER
43 REVOKE SELECT ON *.* FROM r1;
44 --error $EXPECTED_ERROR_NUMBER
45 DROP ROLE r1;
46 --error $EXPECTED_ERROR_NUMBER
47 DROP USER u2;
48 }
49
50 if (!$EXPECT_ERROR)
51 {
52 CREATE USER u2;
53 CREATE ROLE r1;
54 GRANT SELECT ON *.* TO r1;
55 GRANT r1 TO u2;
56 SET DEFAULT ROLE r1 TO u2;
57 ALTER USER u2 IDENTIFIED BY 'abcd';
58 RENAME USER u2 TO u3;
59 RENAME USER u3 TO u2;
60 SET PASSWORD FOR u2 = 'abcd';
61 REVOKE r1 FROM u2;
62 REVOKE SELECT ON *.* FROM r1;
63 DROP ROLE r1;
64 DROP USER u2;
65 }
66
67 --connection conn_u1
68 ROLLBACK;
69
70 --connection conn_root_1
71 CREATE USER u2;
72 CREATE ROLE r1;
73 GRANT SELECT ON *.* TO r1;
74 GRANT r1 TO u2;
75 SET DEFAULT ROLE r1 TO u2;
76 ALTER USER u2 IDENTIFIED BY 'abcd';
77 RENAME USER u2 TO u3;
78 RENAME USER u3 TO u2;
79 SET PASSWORD FOR u2 = 'abcd';
80 REVOKE r1 FROM u2;
81 REVOKE SELECT ON *.* FROM r1;
82 DROP ROLE r1;
83 DROP USER u2;
84
85 # Testcase cleanup
86 --connection default
87 --disconnect conn_root_1
88 --disconnect conn_u1
89 DROP USER u1;
90
91 --disable_connect_log