mariadb/mysql-test/suite/roles
Dmitry Shulga ce7ab467db MDEV-35617: DROP USER should leave no active session for that user
DROP USER looks for sessions by the do-be-dropped user and if found:
* fails with ER_CANNOT_USER in Oracle mode
* continues with ER_ACTIVE_CONNECTIONS_FOR_USER_TO_DROP warning otherwise

Every user being dropped is marked with flag that disallow establishing
a new connections on behalf this user.
2025-07-16 09:14:33 +07:00
..
acl_load_mutex-5170.result
acl_load_mutex-5170.test MDEV-23511 shutdown_server 10 times out, causing server kill at shutdown 2020-08-21 14:48:53 +03:00
acl_statistics.opt
acl_statistics.result Merge 10.10 into 10.11 2023-10-17 16:04:21 +03:00
acl_statistics.test Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
admin.result cleanup: disconnect before DROP USER 2025-07-16 09:14:33 +07:00
admin.test cleanup: disconnect before DROP USER 2025-07-16 09:14:33 +07:00
create_and_drop_current.result MDEV-35617: DROP USER should leave no active session for that user 2025-07-16 09:14:33 +07:00
create_and_drop_current.test
create_and_drop_role.result fix error messages 2025-05-02 13:56:25 +02:00
create_and_drop_role.test
create_and_drop_role_invalid_user_table.result MDEV-27743 Remove Lex::charset 2022-03-22 17:12:15 +04:00
create_and_drop_role_invalid_user_table.test 12.0 branch 2025-02-12 12:37:38 +01:00
create_and_grant_role.result MDEV-26080: SHOW GRANTS does not quote role names properly for DEFAULT ROLE 2021-07-09 08:25:54 +02:00
create_and_grant_role.test
current_role_view-12666.result Merge branch '10.1' into 10.2 2017-07-05 19:08:55 +02:00
current_role_view-12666.test
default_create_user_not_role.result
default_create_user_not_role.test
definer.result MDEV-35617: DROP USER should leave no active session for that user 2025-07-16 09:14:33 +07:00
definer.test MDEV-35617: DROP USER should leave no active session for that user 2025-07-16 09:14:33 +07:00
drop_current_role.result
drop_current_role.test
drop_current_user-5176.result MDEV-35617: DROP USER should leave no active session for that user 2025-07-16 09:14:33 +07:00
drop_current_user-5176.test
drop_routines.result cleanup: disconnect before DROP USER 2025-07-16 09:14:33 +07:00
drop_routines.test cleanup: disconnect before DROP USER 2025-07-16 09:14:33 +07:00
flush_roles-12366.result cleanup: disconnect before DROP USER 2025-07-16 09:14:33 +07:00
flush_roles-12366.test cleanup: disconnect before DROP USER 2025-07-16 09:14:33 +07:00
flush_roles-17898.result MDEV-26080: SHOW GRANTS does not quote role names properly for DEFAULT ROLE 2021-07-09 08:25:54 +02:00
flush_roles-17898.test
grant-5771.result cleanup: disconnect before DROP USER 2025-07-16 09:14:33 +07:00
grant-5771.test cleanup: disconnect before DROP USER 2025-07-16 09:14:33 +07:00
grant_empty.result cleanup: disconnect before DROP USER 2025-07-16 09:14:33 +07:00
grant_empty.test cleanup: disconnect before DROP USER 2025-07-16 09:14:33 +07:00
grant_proxy-5526.result MDEV-20076: SHOW GRANTS does not quote role names properly 2020-02-05 17:22:26 +01:00
grant_proxy-5526.test
grant_revoke_current.result fix error messages 2025-05-02 13:56:25 +02:00
grant_revoke_current.test fix error messages 2025-05-02 13:56:25 +02:00
grant_role_auto_create_user.result cleanup: disconnect before DROP USER 2025-07-16 09:14:33 +07:00
grant_role_auto_create_user.test cleanup: disconnect before DROP USER 2025-07-16 09:14:33 +07:00
i_s_applicable_roles_is_default.result
i_s_applicable_roles_is_default.test
ip-6401.result cleanup: disconnect before DROP USER 2025-07-16 09:14:33 +07:00
ip-6401.test cleanup: disconnect before DROP USER 2025-07-16 09:14:33 +07:00
none_public.result compare public_name by pointer 2022-11-02 00:25:55 +01:00
none_public.test MDEV-5215 post-review fixes 2022-11-01 22:20:02 +01:00
password.result
password.test
prepare_stmt_with_role.result MDEV-26080: SHOW GRANTS does not quote role names properly for DEFAULT ROLE 2021-07-09 08:25:54 +02:00
prepare_stmt_with_role.test
ps.result
ps.test
rebuild_role_grants.result Merge 10.2 into 10.3 2021-10-21 13:41:04 +03:00
rebuild_role_grants.test MDEV-17964: Assertion `status == 0' failed in add_role_user_mapping_action 2021-10-15 19:19:36 +03:00
recursive.inc cleanup: disconnect before DROP USER 2025-07-16 09:14:33 +07:00
recursive.result cleanup: disconnect before DROP USER 2025-07-16 09:14:33 +07:00
recursive.test
recursive_dbug.result cleanup: disconnect before DROP USER 2025-07-16 09:14:33 +07:00
recursive_dbug.test
rename_user.result Merge branch '10.3' into 10.4 2022-08-02 14:15:39 +02:00
rename_user.test MDEV-29131 Assertion `status == 0' failed when renaming user after deleting table roles_mapping 2022-07-29 21:58:38 +02:00
revoke_all.result MDEV-26080: SHOW GRANTS does not quote role names properly for DEFAULT ROLE 2021-07-09 08:25:54 +02:00
revoke_all.test
role_case_sensitive-10744.result cleanup: disconnect before DROP USER 2025-07-16 09:14:33 +07:00
role_case_sensitive-10744.test cleanup: disconnect before DROP USER 2025-07-16 09:14:33 +07:00
role_grant_propagate.result MDEV-30526 Assertion `rights == merged->cols' failed in update_role_columns 2023-02-21 23:22:56 +01:00
role_grant_propagate.test MDEV-30526 Assertion `rights == merged->cols' failed in update_role_columns 2023-02-21 23:22:56 +01:00
roles_tables_priv-29465.result Merge branch '10.3' into 10.4 2022-10-01 23:07:26 +02:00
roles_tables_priv-29465.test MDEV-29465: Inherited columns privs for roles wrongly set mysql.tables_priv column 2022-09-14 14:40:50 +03:00
rpl_definer.result MDEV-19123 Change default charset from latin1 to utf8mb4 2024-07-11 10:21:07 +04:00
rpl_definer.test
rpl_grant_revoke_current_role-8638.result
rpl_grant_revoke_current_role-8638.test
set_and_drop.result MDEV-28548: ER_TABLEACCESS_DENIED_ERROR is missing information about DB 2022-09-30 08:48:57 +02:00
set_and_drop.test
set_default_role_clear.result MDEV-36397 Record change_user command in MTR output 2025-06-23 20:38:36 +02:00
set_default_role_clear.test
set_default_role_for.result MDEV-36397 Record change_user command in MTR output 2025-06-23 20:38:36 +02:00
set_default_role_for.test
set_default_role_invalid.result MDEV-36397 Record change_user command in MTR output 2025-06-23 20:38:36 +02:00
set_default_role_invalid.test MDEV-26875: Wrong user in SET DEFAULT ROLE error 2023-10-30 18:39:56 +01:00
set_default_role_invalid_skip_name_resolve-master.opt MDEV-26875: Wrong user in SET DEFAULT ROLE error 2023-10-30 18:39:56 +01:00
set_default_role_invalid_skip_name_resolve.result MDEV-26875: Wrong user in SET DEFAULT ROLE error 2023-10-30 18:39:56 +01:00
set_default_role_invalid_skip_name_resolve.test MDEV-26875: Wrong user in SET DEFAULT ROLE error 2023-10-30 18:39:56 +01:00
set_default_role_new_connection.result Merge branch '10.3' into 10.4 2022-10-01 23:07:26 +02:00
set_default_role_new_connection.test
set_default_role_ps-6960.result
set_default_role_ps-6960.test MDEV-31005: Make working cursor-protocol 2024-09-18 18:39:26 +07:00
set_role-5232.result MDEV-28548: ER_TABLEACCESS_DENIED_ERROR is missing information about DB 2022-09-30 08:48:57 +02:00
set_role-5232.test
set_role-9614.result cleanup: disconnect before DROP USER 2025-07-16 09:14:33 +07:00
set_role-9614.test cleanup: disconnect before DROP USER 2025-07-16 09:14:33 +07:00
set_role-13655.result cleanup: disconnect before DROP USER 2025-07-16 09:14:33 +07:00
set_role-13655.test cleanup: disconnect before DROP USER 2025-07-16 09:14:33 +07:00
set_role-database-recursive.result MDEV-36397 Record change_user command in MTR output 2025-06-23 20:38:36 +02:00
set_role-database-recursive.test
set_role-database-simple.result MDEV-36397 Record change_user command in MTR output 2025-06-23 20:38:36 +02:00
set_role-database-simple.test
set_role-multiple-role.result MDEV-36397 Record change_user command in MTR output 2025-06-23 20:38:36 +02:00
set_role-multiple-role.test
set_role-recursive.result MDEV-36397 Record change_user command in MTR output 2025-06-23 20:38:36 +02:00
set_role-recursive.test move role tests to a dedicated suite 2013-10-21 19:57:25 -07:00
set_role-routine-simple.result MDEV-36397 Record change_user command in MTR output 2025-06-23 20:38:36 +02:00
set_role-routine-simple.test move role tests to a dedicated suite 2013-10-21 19:57:25 -07:00
set_role-simple.result cleanup: disconnect before DROP USER 2025-07-16 09:14:33 +07:00
set_role-simple.test cleanup: disconnect before DROP USER 2025-07-16 09:14:33 +07:00
set_role-table-column-priv.result MDEV-36397 Record change_user command in MTR output 2025-06-23 20:38:36 +02:00
set_role-table-column-priv.test
set_role-table-simple.result MDEV-36397 Record change_user command in MTR output 2025-06-23 20:38:36 +02:00
set_role-table-simple.test
show_create_database-10463.result cleanup: disconnect before DROP USER 2025-07-16 09:14:33 +07:00
show_create_database-10463.test cleanup: disconnect before DROP USER 2025-07-16 09:14:33 +07:00
show_grants.result MDEV-36397 Record change_user command in MTR output 2025-06-23 20:38:36 +02:00
show_grants.test MDEV-24289: show grants missing with grant option 2020-11-26 18:10:40 +01:00
show_grants_replicated.result MDEV-26080: SHOW GRANTS does not quote role names properly for DEFAULT ROLE 2021-07-09 08:25:54 +02:00
show_grants_replicated.test