diff options
| author | Oleksandr Byelkin <sanja@mariadb.com> | 2022-05-11 17:11:49 +0200 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2022-05-20 13:18:58 +0200 |
| commit | 6dc27a2b2de4f2e94d69a979af7e71c2ead4db34 (patch) | |
| tree | 6506f3c8d930eebe22c281e03acfeb93f0810e5b /mysql-test/suite/perfschema/t/privilege.test | |
| parent | bf2bdd1a1a112c3bbdf53da7a663a59fafa62c7d (diff) | |
| download | mariadb-git-bb-10.9-no_hack.tar.gz | |
MDEV-5215 prerequisite: remove test and test_* database hacks in the test suitebb-10.9-no_hack
Diffstat (limited to 'mysql-test/suite/perfschema/t/privilege.test')
| -rw-r--r-- | mysql-test/suite/perfschema/t/privilege.test | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/mysql-test/suite/perfschema/t/privilege.test b/mysql-test/suite/perfschema/t/privilege.test index a0af41e0372..06e7cdf0cae 100644 --- a/mysql-test/suite/perfschema/t/privilege.test +++ b/mysql-test/suite/perfschema/t/privilege.test @@ -8,6 +8,9 @@ show grants; create user 'pfs_user_1'@localhost; create user 'pfs_user_2'@localhost; create user 'pfs_user_3'@localhost; +grant SELECT,INSERT,UPDATE,DELETE,DROP,CREATE on test.* to 'pfs_user_1'@localhost; +grant SELECT,INSERT,UPDATE,DELETE,DROP,CREATE on test.* to 'pfs_user_2'@localhost; +grant SELECT,INSERT,UPDATE,DELETE,DROP,CREATE on test.* to 'pfs_user_3'@localhost; grant ALL on *.* to 'pfs_user_1'@localhost with GRANT OPTION; # Test denied privileges on performance_schema.* @@ -228,7 +231,7 @@ flush privileges; --echo # Setup user CREATE user pfs_user_4; ---connect (pfs_user_4, localhost, pfs_user_4, , ) +--connect (pfs_user_4, localhost, pfs_user_4, ,"*NO-ONE*") --echo # --echo # WL#4818, NFS4: Normal user does not have access to view data |