diff options
| author | unknown <davi@mysql.com/endora.local> | 2008-02-06 11:20:15 -0200 |
|---|---|---|
| committer | unknown <davi@mysql.com/endora.local> | 2008-02-06 11:20:15 -0200 |
| commit | 3616b9136f2e44a73f49412ffafbe18d4c4688d9 (patch) | |
| tree | d55a87953d43170e7417ab75178aa49c50c07761 /mysql-test/t/show_check.test | |
| parent | ee42ff6398a1e1ccc1a820f63609849259fad768 (diff) | |
| download | mariadb-git-3616b9136f2e44a73f49412ffafbe18d4c4688d9.tar.gz | |
Bug#32710: SHOW INNODB STATUS requires SUPER
Changed "SHOW ENGINE ... STATUS" and "SHOW ENGINE ... MUTEX"
to require the PROCESS privilege, instead of SUPER.
Fixed by Damien Katz
mysql-test/r/show_check.result:
Add test case result for Bug#32710
mysql-test/t/show_check.test:
Add test case for Bug#32710
sql/sql_parse.cc:
Require PROCESS privilege instead of SUPER.
Diffstat (limited to 'mysql-test/t/show_check.test')
| -rw-r--r-- | mysql-test/t/show_check.test | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/t/show_check.test b/mysql-test/t/show_check.test index 34e1941c9d7..613e9acc4c4 100644 --- a/mysql-test/t/show_check.test +++ b/mysql-test/t/show_check.test @@ -1115,5 +1115,24 @@ DROP EVENT ev1; SHOW TABLE TYPES; --enable_result_log +# +# Bug #32710: SHOW INNODB STATUS requires SUPER +# + + +CREATE USER test_u@localhost; +GRANT PROCESS ON *.* TO test_u@localhost; + +connect (conn1, localhost, test_u,,); + +--disable_result_log +SHOW ENGINE MYISAM MUTEX; +SHOW ENGINE MYISAM STATUS; +--enable_result_log + +disconnect conn1; +connection default; +DROP USER test_u@localhost; + --echo End of 5.1 tests |