diff options
| author | unknown <iggy@mysql.com> | 2006-06-27 20:10:49 -0400 |
|---|---|---|
| committer | unknown <iggy@mysql.com> | 2006-06-27 20:10:49 -0400 |
| commit | 0f9725ad1fb99385ab0d184cf0851670fee37bbe (patch) | |
| tree | 6daf13b3703255dfea62af64bc035bcd630eb4a0 /mysql-test/r/grant2.result | |
| parent | f4a07612efd66a559fe06810deee5e38cd96d03c (diff) | |
| download | mariadb-git-0f9725ad1fb99385ab0d184cf0851670fee37bbe.tar.gz | |
Bug#16180 Setting SQL_LOG_OFF without SUPER privilege is silently ignored
mysql-test/r/grant2.result:
Added results for bug#16180
mysql-test/t/grant2.test:
Added test for bug# 16180
sql/set_var.cc:
Verify user has appropiate rights before setting the sql_log_off system variable.
Diffstat (limited to 'mysql-test/r/grant2.result')
| -rw-r--r-- | mysql-test/r/grant2.result | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/r/grant2.result b/mysql-test/r/grant2.result index 85963705718..c047dc033c6 100644 --- a/mysql-test/r/grant2.result +++ b/mysql-test/r/grant2.result @@ -143,3 +143,13 @@ flush privileges; drop user mysqltest_3@host3; drop user mysqltest_1@host1, mysqltest_2@host2, mysqltest_4@host4, mysqltest_5@host5, mysqltest_6@host6, mysqltest_7@host7; +create database mysqltest_1; +grant select, insert, update on `mysqltest\_1`.* to mysqltest_1@localhost; +set sql_log_off = 1; +ERROR HY000: Access denied; you need the SUPER privilege for this operation +set sql_log_bin = 0; +ERROR HY000: Access denied; you need the SUPER privilege for this operation +delete from mysql.user where user like 'mysqltest\_1'; +delete from mysql.db where user like 'mysqltest\_1'; +drop database mysqltest_1; +flush privileges; |