mirror of
https://github.com/MariaDB/server.git
synced 2025-08-24 03:12:20 +02:00
e3d9369774
let's always disconnect a user connection before dropping the said user. MariaDB is traditionally very tolerant to active connections of the dropped user, which isn't the case for most other databases. Let's avoid unintentionally spreading incompatible behavior and disconnect before drop. Except in cases when the test specifically tests such a behavior.
49 lines
1.2 KiB
Text
49 lines
1.2 KiB
Text
source include/not_embedded.inc;
|
|
|
|
--echo #
|
|
--echo # MDEV-13655: SET ROLE does not properly grant privileges.
|
|
--echo #
|
|
--echo # We must test that if additional db privileges get granted to a role
|
|
--echo # which previously inherited privileges from another granted role
|
|
--echo # keep the internal memory structures intact.
|
|
--echo #
|
|
|
|
create role simple;
|
|
|
|
--echo #
|
|
--echo # First we create an entry with privileges for databases for the simple role.
|
|
--echo #
|
|
grant select, insert, update, delete, lock tables, execute on t.* to simple;
|
|
create role admin;
|
|
|
|
--echo #
|
|
--echo # Now we grant the simple role to admin. This means that db privileges
|
|
--echo # should propagate to admin.
|
|
--echo #
|
|
grant simple to admin;
|
|
show grants for admin;
|
|
|
|
--echo #
|
|
--echo # Finally, we give the admin all the available privileges for the db.
|
|
--echo #
|
|
grant all on t.* to admin;
|
|
|
|
--echo #
|
|
--echo # Create a user to test out the new roles;
|
|
--echo #
|
|
create user foo;
|
|
grant admin to foo;
|
|
|
|
connect (foo,localhost,foo,,,,,);
|
|
--error ER_DBACCESS_DENIED_ERROR
|
|
create database t;
|
|
set role admin;
|
|
show grants;
|
|
create database t;
|
|
drop database t;
|
|
|
|
connection default;
|
|
disconnect foo;
|
|
drop role simple;
|
|
drop role admin;
|
|
drop user foo;
|