| 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 |