diff options
Diffstat (limited to 'mysql-test/t/sp-security.test')
| -rw-r--r-- | mysql-test/t/sp-security.test | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/t/sp-security.test b/mysql-test/t/sp-security.test index 8fc51357bc4..046a9018472 100644 --- a/mysql-test/t/sp-security.test +++ b/mysql-test/t/sp-security.test @@ -17,6 +17,10 @@ drop database if exists db1_secret; # Create our secret database create database db1_secret; +# Can create a procedure in other db +create procedure db1_secret.dummy() begin end; +drop procedure db1_secret.dummy; + use db1_secret; create table t1 ( u varchar(64), i int ); @@ -39,6 +43,7 @@ select db(); connect (con2user1,localhost,user1,,); connect (con3anon,localhost,anon,,); + # # User1 can # @@ -52,6 +57,13 @@ select db1_secret.db(); --error 1044 select * from db1_secret.t1; +# ...and not this +--error 1049 +create procedure db1_secret.dummy() begin end; +--error 1298 +drop procedure db1_secret.dummy; + + # # Anonymous can # @@ -65,6 +77,13 @@ select db1_secret.db(); --error 1044 select * from db1_secret.t1; +# ...and not this +--error 1049 +create procedure db1_secret.dummy() begin end; +--error 1298 +drop procedure db1_secret.dummy; + + # # Check it out # |