Debian Codegraph @

mysql-test/suite/roles/rebuild_role_grants.result

raw
1 create role r1;
2 create user u1;
3 grant r1 to u1;
4 show grants for u1;
5 Grants for u1@%
6 GRANT USAGE ON *.* TO `u1`@`%`
7 GRANT `r1` TO `u1`@`%`
8 create user u2;
9 show grants for u1;
10 Grants for u1@%
11 GRANT USAGE ON *.* TO `u1`@`%`
12 GRANT `r1` TO `u1`@`%`
13 show grants for u2;
14 Grants for u2@%
15 GRANT USAGE ON *.* TO `u2`@`%`
16 select * from mysql.roles_mapping;
17 Host User Role Admin_option
18 % u1 r1 N
19 localhost root r1 Y
20 revoke r1 from u1;
21 revoke r1 from u1;
22 ERROR HY000: Cannot revoke role 'r1' from: 'u1'@'%'
23 show grants for u1;
24 Grants for u1@%
25 GRANT USAGE ON *.* TO `u1`@`%`
26 select * from mysql.roles_mapping;
27 Host User Role Admin_option
28 localhost root r1 Y
29 grant r1 to u1;
30 grant r1 to u1;
31 show grants for u1;
32 Grants for u1@%
33 GRANT USAGE ON *.* TO `u1`@`%`
34 GRANT `r1` TO `u1`@`%`
35 select * from mysql.roles_mapping;
36 Host User Role Admin_option
37 % u1 r1 N
38 localhost root r1 Y
39 drop role r1;
40 show grants for u1;
41 Grants for u1@%
42 GRANT USAGE ON *.* TO `u1`@`%`
43 select * from mysql.roles_mapping;
44 Host User Role Admin_option
45 create role r1;
46 grant r1 to u1;
47 select * from mysql.roles_mapping;
48 Host User Role Admin_option
49 % u1 r1 N
50 localhost root r1 Y
51 drop user u1;
52 show grants for u1;
53 ERROR 42000: There is no such grant defined for user 'u1' on host '%'
54 select * from mysql.roles_mapping;
55 Host User Role Admin_option
56 localhost root r1 Y
57 drop role r1;
58 drop user u2;
59 create user foo@localhost;
60 grant create user on *.* to foo@localhost;
61 connect con1, localhost, foo,,;
62 create role look, isp, xxx, ppp;
63 rename user current_user to nnnn@'%';
64 drop role look, isp, xxx, ppp;
65 connection default;
66 disconnect con1;
67 drop user nnnn@'%';
68 CREATE USER u@localhost;
69 CREATE ROLE r1;
70 CREATE ROLE r2;
71 CREATE ROLE r3;
72 CREATE ROLE r4;
73 CREATE ROLE r5;
74 CREATE ROLE r6;
75 CREATE ROLE r7;
76 CREATE ROLE r8;
77 CREATE ROLE r9;
78 CREATE ROLE r10;
79 CREATE ROLE r11;
80 CREATE ROLE r12;
81 CREATE ROLE r13;
82 CREATE ROLE r14;
83 CREATE ROLE r15;
84 CREATE ROLE r16;
85 CREATE ROLE r17;
86 CREATE ROLE r18;
87 CREATE ROLE r19;
88 CREATE ROLE r20;
89 CREATE ROLE r21;
90 CREATE ROLE r22;
91 CREATE ROLE r23;
92 CREATE ROLE r24;
93 CREATE ROLE r25;
94 CREATE ROLE r26;
95 CREATE ROLE r27;
96 CREATE ROLE r28;
97 CREATE ROLE r29;
98 CREATE ROLE r30;
99 CREATE ROLE r31;
100 CREATE ROLE r32;
101 CREATE ROLE r33;
102 CREATE ROLE r34;
103 CREATE ROLE r35;
104 CREATE ROLE r36;
105 CREATE ROLE r37;
106 CREATE ROLE r38;
107 CREATE ROLE r39;
108 CREATE ROLE r40;
109 CREATE ROLE r41;
110 CREATE ROLE r42;
111 CREATE ROLE r43;
112 CREATE ROLE r44;
113 CREATE ROLE r45;
114 CREATE ROLE r46;
115 CREATE ROLE r47;
116 CREATE ROLE r48;
117 CREATE ROLE r49;
118 CREATE ROLE r50;
119 CREATE ROLE r51;
120 CREATE ROLE r52;
121 CREATE ROLE r53;
122 CREATE ROLE r54;
123 CREATE ROLE r55;
124 CREATE ROLE r56;
125 CREATE ROLE r57;
126 CREATE ROLE r58;
127 CREATE ROLE r59;
128 CREATE ROLE r60;
129 CREATE ROLE r61;
130 CREATE ROLE r62;
131 CREATE ROLE r63;
132 CREATE ROLE r64;
133 CREATE ROLE r65;
134 CREATE ROLE r66;
135 CREATE ROLE r67;
136 CREATE ROLE r68;
137 CREATE ROLE r69;
138 CREATE ROLE r70;
139 CREATE ROLE r71;
140 CREATE ROLE r72;
141 CREATE ROLE r73;
142 CREATE ROLE r74;
143 CREATE ROLE r75;
144 CREATE ROLE r76;
145 CREATE ROLE r77;
146 CREATE ROLE r78;
147 CREATE ROLE r79;
148 CREATE ROLE r80;
149 CREATE ROLE r81;
150 CREATE ROLE r82;
151 CREATE ROLE r83;
152 CREATE ROLE r84;
153 CREATE ROLE r85;
154 CREATE ROLE r86;
155 CREATE ROLE r87;
156 CREATE ROLE r88;
157 CREATE ROLE r89;
158 CREATE ROLE r90;
159 CREATE ROLE r91;
160 CREATE ROLE r92;
161 CREATE ROLE r93;
162 CREATE ROLE r94;
163 CREATE ROLE r95;
164 CREATE ROLE r96;
165 CREATE ROLE r97;
166 CREATE ROLE r98;
167 CREATE ROLE r99;
168 CREATE ROLE r100;
169 CREATE ROLE r101;
170 CREATE ROLE r102;
171 CREATE ROLE r103;
172 CREATE ROLE r104;
173 CREATE ROLE r105;
174 CREATE ROLE r106;
175 CREATE ROLE r107;
176 CREATE ROLE r108;
177 CREATE ROLE r109;
178 CREATE ROLE r110;
179 CREATE ROLE r111;
180 CREATE ROLE r112;
181 CREATE ROLE r113;
182 CREATE ROLE r114;
183 CREATE ROLE r115;
184 CREATE ROLE r116;
185 CREATE ROLE r117;
186 CREATE ROLE r118;
187 CREATE ROLE r119;
188 CREATE ROLE r120;
189 CREATE ROLE r121;
190 CREATE ROLE r122;
191 CREATE ROLE r123;
192 CREATE ROLE r124;
193 CREATE ROLE r125;
194 CREATE ROLE r126;
195 CREATE ROLE r127;
196 CREATE ROLE r128;
197 CREATE ROLE n;
198 CREATE ROLE d WITH ADMIN n;
199 CREATE ROLE '%' WITH ADMIN u@localhost;
200 DROP ROLE n;
201 CREATE USER 't';
202 DROP ROLE r1;
203 DROP ROLE r2;
204 DROP ROLE r3;
205 DROP ROLE r4;
206 DROP ROLE r5;
207 DROP ROLE r6;
208 DROP ROLE r7;
209 DROP ROLE r8;
210 DROP ROLE r9;
211 DROP ROLE r10;
212 DROP ROLE r11;
213 DROP ROLE r12;
214 DROP ROLE r13;
215 DROP ROLE r14;
216 DROP ROLE r15;
217 DROP ROLE r16;
218 DROP ROLE r17;
219 DROP ROLE r18;
220 DROP ROLE r19;
221 DROP ROLE r20;
222 DROP ROLE r21;
223 DROP ROLE r22;
224 DROP ROLE r23;
225 DROP ROLE r24;
226 DROP ROLE r25;
227 DROP ROLE r26;
228 DROP ROLE r27;
229 DROP ROLE r28;
230 DROP ROLE r29;
231 DROP ROLE r30;
232 DROP ROLE r31;
233 DROP ROLE r32;
234 DROP ROLE r33;
235 DROP ROLE r34;
236 DROP ROLE r35;
237 DROP ROLE r36;
238 DROP ROLE r37;
239 DROP ROLE r38;
240 DROP ROLE r39;
241 DROP ROLE r40;
242 DROP ROLE r41;
243 DROP ROLE r42;
244 DROP ROLE r43;
245 DROP ROLE r44;
246 DROP ROLE r45;
247 DROP ROLE r46;
248 DROP ROLE r47;
249 DROP ROLE r48;
250 DROP ROLE r49;
251 DROP ROLE r50;
252 DROP ROLE r51;
253 DROP ROLE r52;
254 DROP ROLE r53;
255 DROP ROLE r54;
256 DROP ROLE r55;
257 DROP ROLE r56;
258 DROP ROLE r57;
259 DROP ROLE r58;
260 DROP ROLE r59;
261 DROP ROLE r60;
262 DROP ROLE r61;
263 DROP ROLE r62;
264 DROP ROLE r63;
265 DROP ROLE r64;
266 DROP ROLE r65;
267 DROP ROLE r66;
268 DROP ROLE r67;
269 DROP ROLE r68;
270 DROP ROLE r69;
271 DROP ROLE r70;
272 DROP ROLE r71;
273 DROP ROLE r72;
274 DROP ROLE r73;
275 DROP ROLE r74;
276 DROP ROLE r75;
277 DROP ROLE r76;
278 DROP ROLE r77;
279 DROP ROLE r78;
280 DROP ROLE r79;
281 DROP ROLE r80;
282 DROP ROLE r81;
283 DROP ROLE r82;
284 DROP ROLE r83;
285 DROP ROLE r84;
286 DROP ROLE r85;
287 DROP ROLE r86;
288 DROP ROLE r87;
289 DROP ROLE r88;
290 DROP ROLE r89;
291 DROP ROLE r90;
292 DROP ROLE r91;
293 DROP ROLE r92;
294 DROP ROLE r93;
295 DROP ROLE r94;
296 DROP ROLE r95;
297 DROP ROLE r96;
298 DROP ROLE r97;
299 DROP ROLE r98;
300 DROP ROLE r99;
301 DROP ROLE r100;
302 DROP ROLE r101;
303 DROP ROLE r102;
304 DROP ROLE r103;
305 DROP ROLE r104;
306 DROP ROLE r105;
307 DROP ROLE r106;
308 DROP ROLE r107;
309 DROP ROLE r108;
310 DROP ROLE r109;
311 DROP ROLE r110;
312 DROP ROLE r111;
313 DROP ROLE r112;
314 DROP ROLE r113;
315 DROP ROLE r114;
316 DROP ROLE r115;
317 DROP ROLE r116;
318 DROP ROLE r117;
319 DROP ROLE r118;
320 DROP ROLE r119;
321 DROP ROLE r120;
322 DROP ROLE r121;
323 DROP ROLE r122;
324 DROP ROLE r123;
325 DROP ROLE r124;
326 DROP ROLE r125;
327 DROP ROLE r126;
328 DROP ROLE r127;
329 DROP ROLE r128;
330 DROP ROLE d;
331 DROP ROLE '%';
332 DROP USER 't';
333 DROP USER u@localhost;