summaryrefslogtreecommitdiff
path: root/mysql-test/suite/sys_vars/t/automatic_sp_privileges_func.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/sys_vars/t/automatic_sp_privileges_func.test')
-rw-r--r--mysql-test/suite/sys_vars/t/automatic_sp_privileges_func.test2
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/suite/sys_vars/t/automatic_sp_privileges_func.test b/mysql-test/suite/sys_vars/t/automatic_sp_privileges_func.test
index fd2dbefe7f6..25fda7d664a 100644
--- a/mysql-test/suite/sys_vars/t/automatic_sp_privileges_func.test
+++ b/mysql-test/suite/sys_vars/t/automatic_sp_privileges_func.test
@@ -38,7 +38,9 @@ INSERT INTO t1 VALUES('Procedure Executed.');
#
CREATE USER 'userTest'@'localhost';
+GRANT CREATE ROUTINE, SELECT ON test.* to 'userTest'@'localhost';
CREATE USER 'userTest1'@'localhost';
+GRANT CREATE ROUTINE, SELECT ON test.* to 'userTest1'@'localhost';
#
# Value TRUE