Debian Codegraph @

mysql-test/suite/x/r/roles_xplugin.result

raw
1 RUN DROP ROLE IF EXISTS r1, r2, u1@localhost, u2
2
3 0 rows affected
4 RUN CREATE USER u1@localhost IDENTIFIED BY 'foo', u2
5
6 0 rows affected
7 RUN CREATE ROLE r1,r2
8
9 0 rows affected
10 RUN GRANT r1, r2 TO u1@localhost, u2
11
12 0 rows affected
13 RUN GRANT ALL ON test.* TO r2
14
15 0 rows affected
16 RUN ALTER USER u1@localhost DEFAULT ROLE r1,r2
17
18 0 rows affected
19 RUN SELECT CURRENT_ROLE()
20 CURRENT_ROLE()
21 NONE
22 0 rows affected
23 RUN SET ROLE ALL
24
25 0 rows affected
26 RUN SET ROLE DEFAULT
27
28 0 rows affected
29 RUN SET ROLE NONE
30
31 0 rows affected
32 RUN DROP ROLE r1,r2
33
34 0 rows affected
35 RUN DROP USER u1@localhost, u2
36
37 0 rows affected
38 Mysqlx.Ok {
39 msg: "bye!"
40 }
41 ok