diff options
| author | jimw@mysql.com <> | 2005-08-11 17:04:16 -0700 |
|---|---|---|
| committer | jimw@mysql.com <> | 2005-08-11 17:04:16 -0700 |
| commit | 3a815f45bd7030cddf636d5018faf13918f99ca6 (patch) | |
| tree | cdafc43f17feb3e2c94df11c7bcc6df37c52eae3 /mysql-test/r/sp-security.result | |
| parent | 03162293da783ce3f153ac8f713e0cea103b440b (diff) | |
| download | mariadb-git-3a815f45bd7030cddf636d5018faf13918f99ca6.tar.gz | |
Avoid spurious error when restoring INFORMATION_SCHEMA as the current
database after failing to execute a stored procedure in an inaccessible
database. (Bug #12318)
Diffstat (limited to 'mysql-test/r/sp-security.result')
| -rw-r--r-- | mysql-test/r/sp-security.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/r/sp-security.result b/mysql-test/r/sp-security.result index 184978e4a0d..d78f5fc36ea 100644 --- a/mysql-test/r/sp-security.result +++ b/mysql-test/r/sp-security.result @@ -236,3 +236,16 @@ drop procedure bug7291_2; drop procedure bug7291_0; REVOKE ALL PRIVILEGES, GRANT OPTION FROM user1@localhost; drop user user1@localhost; +drop database if exists mysqltest_1; +create database mysqltest_1; +create procedure mysqltest_1.p1() +begin +select 1 from dual; +end// +grant usage on *.* to mysqltest_1@localhost; +call mysqltest_1.p1(); +ERROR 42000: execute command denied to user 'mysqltest_1'@'localhost' for routine 'mysqltest_1.p1' +drop procedure mysqltest_1.p1; +drop database mysqltest_1; +revoke usage on *.* from mysqltest_1@localhost; +drop user mysqltest_1@localhost; |