Debian Codegraph @

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

raw
1 create user unpriv@localhost;
2 set password for unpriv@localhost = 'x';
3 grant connection_admin on *.* to unpriv@localhost;
4 create role sys_user_role;
5 grant system_user on *.* to sys_user_role;
6 grant sys_user_role to unpriv@localhost;
7 client_id user host sql_session
8 1 x_root localhost $SESSION
9 command ok
10 connecting...
11 active session is now 'aux'
12 client_id user host sql_session
13 1 x_root localhost $SESSION
14 2 x_root localhost $SESSION
15 command ok
16 switched to session default
17 client_id user host sql_session
18 1 x_root localhost $SESSION
19 2 x_root localhost $SESSION
20 command ok
21 connecting...
22 active session is now 'unpriv'
23 Should list unprivs session only
24 client_id user host sql_session
25 3 unpriv localhost $SESSION
26 command ok
27 Try to kill a x_root session from regular session
28 Got expected error:
29 Mysqlx.Error {
30 severity: ERROR
31 code: 1095
32 msg: "You are not owner of thread"
33 sql_state: "HY000"
34 }
35
36 promote regular session to power session
37 RUN set role sys_user_role
38
39 0 rows affected
40 Try to kill a x_root session from unpriv
41
42 command ok
43 switched to session default
44 Should two sessions
45 client_id user host sql_session
46 1 x_root localhost $SESSION
47 3 unpriv localhost $SESSION
48 command ok
49 Now kill one power_session from another power_session
50
51 command ok
52 Should list only x_root session
53 client_id user host sql_session
54 1 x_root localhost $SESSION
55 command ok
56 RUN drop schema if exists xtest
57
58 0 rows affected
59 RUN drop user unpriv@localhost
60
61 0 rows affected
62 RUN drop role sys_user_role
63
64 0 rows affected
65 Mysqlx.Ok {
66 msg: "bye!"
67 }
68 ok