diff options
| author | unknown <gluh@gluh.mysql.r18.ru> | 2004-11-02 17:45:26 +0300 |
|---|---|---|
| committer | unknown <gluh@gluh.mysql.r18.ru> | 2004-11-02 17:45:26 +0300 |
| commit | efa50b5c03f703191fc4df6f5f083232350ed5bf (patch) | |
| tree | 9028a53d5a17350d315c3bba47daa49454e964fb /mysql-test/r/grant2.result | |
| parent | 81ef1a41d7a3fe073831d6265e9d5491f9702f29 (diff) | |
| download | mariadb-git-efa50b5c03f703191fc4df6f5f083232350ed5bf.tar.gz | |
WL#1437 :don't create new users with GRANT
Diffstat (limited to 'mysql-test/r/grant2.result')
| -rw-r--r-- | mysql-test/r/grant2.result | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/grant2.result b/mysql-test/r/grant2.result index 31e506d2679..c95b86ea831 100644 --- a/mysql-test/r/grant2.result +++ b/mysql-test/r/grant2.result @@ -12,6 +12,14 @@ mysqltest_1@localhost grant all privileges on `my\_1`.* to mysqltest_2@localhost with grant option; grant all privileges on `my_%`.* to mysqltest_3@localhost with grant option; ERROR 42000: Access denied for user 'mysqltest_1'@'localhost' to database 'my_%' +set @@sql_mode='NO_AUTO_CREATE_USER'; +select @@sql_mode; +@@sql_mode +NO_AUTO_CREATE_USER +grant select on `my\_1`.* to mysqltest_4@localhost with grant option; +ERROR 42000: 'mysqltest_1'@'localhost' is not allowed to create new users +grant select on `my\_1`.* to mysqltest_4@localhost identified by 'mypass' +with grant option; show grants for mysqltest_1@localhost; Grants for mysqltest_1@localhost GRANT USAGE ON *.* TO 'mysqltest_1'@'localhost' |