Debian Codegraph @

mysql-test/suite/roles/revoke_all.result

raw
1 create role r1;
2 create role r2;
3 create role r3;
4 create role r4;
5 create user u1;
6 grant r2 to r1;
7 grant r3 to r2;
8 grant r4 to r3;
9 grant r1 to u1;
10 grant r4 to r1;
11 show grants for u1;
12 Grants for u1@%
13 GRANT USAGE ON *.* TO `u1`@`%`
14 GRANT `r1` TO `u1`@`%`
15 show grants for r1;
16 Grants for r1
17 GRANT USAGE ON *.* TO `r1`
18 GRANT USAGE ON *.* TO `r2`
19 GRANT USAGE ON *.* TO `r3`
20 GRANT USAGE ON *.* TO `r4`
21 GRANT `r2` TO `r1`
22 GRANT `r3` TO `r2`
23 GRANT `r4` TO `r1`
24 GRANT `r4` TO `r3`
25 grant SELECT on *.* to u1;
26 grant INSERT on mysql.* to r1;
27 grant DELETE on mysql.roles_mapping to r2;
28 grant UPDATE on mysql.user to r3;
29 create function mysql.test_func (s CHAR(20))
30 returns CHAR(50) DETERMINISTIC
31 return concat('Test string: ',s);
32 create procedure mysql.test_proc (OUT param1 INT)
33 begin
34 select COUNT(*) into param1 from mysql.roles_mapping;
35 end|
36 grant execute on function mysql.test_func to r2;
37 grant execute on procedure mysql.test_proc to r3;
38 grant execute on mysql.* to r4;
39 show grants for r1;
40 Grants for r1
41 GRANT DELETE ON `mysql`.`roles_mapping` TO `r2`
42 GRANT EXECUTE ON FUNCTION `mysql`.`test_func` TO `r2`
43 GRANT EXECUTE ON PROCEDURE `mysql`.`test_proc` TO `r3`
44 GRANT EXECUTE ON `mysql`.* TO `r4`
45 GRANT INSERT ON `mysql`.* TO `r1`
46 GRANT UPDATE ON `mysql`.`user` TO `r3`
47 GRANT USAGE ON *.* TO `r1`
48 GRANT USAGE ON *.* TO `r2`
49 GRANT USAGE ON *.* TO `r3`
50 GRANT USAGE ON *.* TO `r4`
51 GRANT `r2` TO `r1`
52 GRANT `r3` TO `r2`
53 GRANT `r4` TO `r1`
54 GRANT `r4` TO `r3`
55 show grants for r2;
56 Grants for r2
57 GRANT DELETE ON `mysql`.`roles_mapping` TO `r2`
58 GRANT EXECUTE ON FUNCTION `mysql`.`test_func` TO `r2`
59 GRANT EXECUTE ON PROCEDURE `mysql`.`test_proc` TO `r3`
60 GRANT EXECUTE ON `mysql`.* TO `r4`
61 GRANT UPDATE ON `mysql`.`user` TO `r3`
62 GRANT USAGE ON *.* TO `r2`
63 GRANT USAGE ON *.* TO `r3`
64 GRANT USAGE ON *.* TO `r4`
65 GRANT `r3` TO `r2`
66 GRANT `r4` TO `r3`
67 show grants for r3;
68 Grants for r3
69 GRANT EXECUTE ON PROCEDURE `mysql`.`test_proc` TO `r3`
70 GRANT EXECUTE ON `mysql`.* TO `r4`
71 GRANT UPDATE ON `mysql`.`user` TO `r3`
72 GRANT USAGE ON *.* TO `r3`
73 GRANT USAGE ON *.* TO `r4`
74 GRANT `r4` TO `r3`
75 show grants for r4;
76 Grants for r4
77 GRANT EXECUTE ON `mysql`.* TO `r4`
78 GRANT USAGE ON *.* TO `r4`
79 revoke all privileges, grant option from r4;
80 show grants for r1;
81 Grants for r1
82 GRANT DELETE ON `mysql`.`roles_mapping` TO `r2`
83 GRANT EXECUTE ON FUNCTION `mysql`.`test_func` TO `r2`
84 GRANT EXECUTE ON PROCEDURE `mysql`.`test_proc` TO `r3`
85 GRANT INSERT ON `mysql`.* TO `r1`
86 GRANT UPDATE ON `mysql`.`user` TO `r3`
87 GRANT USAGE ON *.* TO `r1`
88 GRANT USAGE ON *.* TO `r2`
89 GRANT USAGE ON *.* TO `r3`
90 GRANT USAGE ON *.* TO `r4`
91 GRANT `r2` TO `r1`
92 GRANT `r3` TO `r2`
93 GRANT `r4` TO `r1`
94 GRANT `r4` TO `r3`
95 show grants for r2;
96 Grants for r2
97 GRANT DELETE ON `mysql`.`roles_mapping` TO `r2`
98 GRANT EXECUTE ON FUNCTION `mysql`.`test_func` TO `r2`
99 GRANT EXECUTE ON PROCEDURE `mysql`.`test_proc` TO `r3`
100 GRANT UPDATE ON `mysql`.`user` TO `r3`
101 GRANT USAGE ON *.* TO `r2`
102 GRANT USAGE ON *.* TO `r3`
103 GRANT USAGE ON *.* TO `r4`
104 GRANT `r3` TO `r2`
105 GRANT `r4` TO `r3`
106 show grants for r3;
107 Grants for r3
108 GRANT EXECUTE ON PROCEDURE `mysql`.`test_proc` TO `r3`
109 GRANT UPDATE ON `mysql`.`user` TO `r3`
110 GRANT USAGE ON *.* TO `r3`
111 GRANT USAGE ON *.* TO `r4`
112 GRANT `r4` TO `r3`
113 show grants for r4;
114 Grants for r4
115 GRANT USAGE ON *.* TO `r4`
116 revoke all privileges, grant option from r3;
117 show grants for r1;
118 Grants for r1
119 GRANT DELETE ON `mysql`.`roles_mapping` TO `r2`
120 GRANT EXECUTE ON FUNCTION `mysql`.`test_func` TO `r2`
121 GRANT INSERT ON `mysql`.* TO `r1`
122 GRANT USAGE ON *.* TO `r1`
123 GRANT USAGE ON *.* TO `r2`
124 GRANT USAGE ON *.* TO `r3`
125 GRANT USAGE ON *.* TO `r4`
126 GRANT `r2` TO `r1`
127 GRANT `r3` TO `r2`
128 GRANT `r4` TO `r1`
129 show grants for r2;
130 Grants for r2
131 GRANT DELETE ON `mysql`.`roles_mapping` TO `r2`
132 GRANT EXECUTE ON FUNCTION `mysql`.`test_func` TO `r2`
133 GRANT USAGE ON *.* TO `r2`
134 GRANT USAGE ON *.* TO `r3`
135 GRANT `r3` TO `r2`
136 show grants for r3;
137 Grants for r3
138 GRANT USAGE ON *.* TO `r3`
139 show grants for r4;
140 Grants for r4
141 GRANT USAGE ON *.* TO `r4`
142 revoke all privileges, grant option from r2;
143 show grants for r1;
144 Grants for r1
145 GRANT INSERT ON `mysql`.* TO `r1`
146 GRANT USAGE ON *.* TO `r1`
147 GRANT USAGE ON *.* TO `r2`
148 GRANT USAGE ON *.* TO `r4`
149 GRANT `r2` TO `r1`
150 GRANT `r4` TO `r1`
151 show grants for r2;
152 Grants for r2
153 GRANT USAGE ON *.* TO `r2`
154 show grants for r3;
155 Grants for r3
156 GRANT USAGE ON *.* TO `r3`
157 show grants for r4;
158 Grants for r4
159 GRANT USAGE ON *.* TO `r4`
160 revoke all privileges, grant option from r1;
161 show grants for r1;
162 Grants for r1
163 GRANT USAGE ON *.* TO `r1`
164 show grants for r2;
165 Grants for r2
166 GRANT USAGE ON *.* TO `r2`
167 show grants for r3;
168 Grants for r3
169 GRANT USAGE ON *.* TO `r3`
170 show grants for r4;
171 Grants for r4
172 GRANT USAGE ON *.* TO `r4`
173 revoke all privileges, grant option from u1;
174 show grants for u1;
175 Grants for u1@%
176 GRANT USAGE ON *.* TO `u1`@`%`
177 drop function mysql.test_func;
178 drop procedure mysql.test_proc;
179 show grants for r1;
180 Grants for r1
181 GRANT USAGE ON *.* TO `r1`
182 drop role r1, r2, r3, r4;
183 drop user u1;