Debian Codegraph @

mysql-test/suite/roles/grant_role_auto_create_user.result

raw
1 create database db;
2 create role auto_create;
3 create user auto_create;
4 grant all on db.* to auto_create;
5 create user foo@localhost;
6 grant auto_create to foo@localhost;
7 create user bar@localhost identified by 'baz';
8 grant auto_create to bar@localhost;
9 connect con1,localhost,foo,,;
10 set role 'auto_create';
11 use db;
12 create table t1 (i int);
13 disconnect con1;
14 connect con1,localhost,bar,baz,;
15 set role auto_create;
16 use db;
17 insert into t1 values (1);
18 disconnect con1;
19 connection default;
20 drop user foo@localhost, bar@localhost;
21 set sql_mode = 'no_auto_create_user';
22 grant auto_create to foo@localhost;
23 ERROR 28000: Can't find any matching row in the user table
24 grant auto_create to bar@localhost identified by 'baz';
25 select user, host from mysql.user where user = 'bar';
26 User Host
27 bar localhost
28 set sql_mode = '';
29 connect con1,localhost,bar,baz,;
30 set role auto_create;
31 use db;
32 drop table t1;
33 disconnect con1;
34 connection default;
35 create user foo@localhost;
36 connect con1, localhost, foo,,;
37 set sql_mode = '';
38 grant auto_create to bar2@localhost;
39 ERROR 28000: Access denied for user 'foo'@'localhost'
40 grant auto_create to foo2@localhost;
41 ERROR 28000: Access denied for user 'foo'@'localhost'
42 set sql_mode = 'no_auto_create_user';
43 grant auto_create to bar2@localhost;
44 ERROR 28000: Access denied for user 'foo'@'localhost'
45 grant auto_create to foo2@localhost identified by 'pass';
46 ERROR 28000: Access denied for user 'foo'@'localhost'
47 disconnect con1;
48 connection default;
49 grant auto_create to foo@localhost;
50 connect con1, localhost, foo,,;
51 set sql_mode = '';
52 grant auto_create to bar@localhost;
53 ERROR 28000: Access denied for user 'foo'@'localhost'
54 grant auto_create to bar2@localhost;
55 ERROR 28000: Access denied for user 'foo'@'localhost'
56 grant auto_create to foo2@localhost identified by 'pass';
57 ERROR 28000: Access denied for user 'foo'@'localhost'
58 set sql_mode = 'no_auto_create_user';
59 grant auto_create to bar2@localhost;
60 ERROR 28000: Access denied for user 'foo'@'localhost'
61 grant auto_create to foo2@localhost identified by 'pass';
62 ERROR 28000: Access denied for user 'foo'@'localhost'
63 connection default;
64 grant auto_create to foo@localhost with admin option;
65 disconnect con1;
66 connect con1, localhost, foo,,;
67 set sql_mode = '';
68 grant auto_create to bar@localhost;
69 grant auto_create to bar2@localhost;
70 ERROR 42000: You are not allowed to create a user with GRANT
71 grant auto_create to foo2@localhost identified by 'pass';
72 ERROR 42000: You are not allowed to create a user with GRANT
73 set sql_mode = 'no_auto_create_user';
74 grant auto_create to bar2@localhost;
75 ERROR 28000: Can't find any matching row in the user table
76 grant auto_create to foo2@localhost identified by 'pass';
77 ERROR 42000: You are not allowed to create a user with GRANT
78 connection default;
79 drop user foo@localhost;
80 drop user bar@localhost;
81 drop role auto_create;
82 drop user auto_create;
83 drop database db;