1drop database if exists events_test;
2drop database if exists mysqltest_db2;
3create database events_test;
4use events_test;
5create user mysqltest_user1@localhost;
6grant create, insert, select, delete on mysqltest_db2.*
7to mysqltest_user1@localhost;
8create database mysqltest_db2;
9connect  conn1,localhost,mysqltest_user1,,mysqltest_db2;
10set autocommit=off;
11select @@autocommit;
12@@autocommit
130
14create table t1 (a varchar(255)) engine=innodb;
15begin work;
16insert into t1 (a) values ("OK: create event: insufficient privileges");
17create event e1 on schedule every 1 day do select 1;
18ERROR 42000: Access denied for user 'mysqltest_user1'@'localhost' to database 'mysqltest_db2'
19rollback work;
20select * from t1;
21a
22OK: create event: insufficient privileges
23delete from t1;
24commit work;
25begin work;
26insert into t1 (a) values ("OK: alter event: insufficient privileges");
27alter event e1 on schedule every 1 day do select 1;
28ERROR 42000: Access denied for user 'mysqltest_user1'@'localhost' to database 'mysqltest_db2'
29rollback work;
30select * from t1;
31a
32OK: alter event: insufficient privileges
33delete from t1;
34commit work;
35begin work;
36insert into t1 (a) values ("OK: drop event: insufficient privileges");
37drop event e1;
38ERROR 42000: Access denied for user 'mysqltest_user1'@'localhost' to database 'mysqltest_db2'
39rollback work;
40select * from t1;
41a
42OK: drop event: insufficient privileges
43delete from t1;
44commit work;
45disconnect conn1;
46connection default;
47drop user mysqltest_user1@localhost;
48drop database mysqltest_db2;
49drop database events_test;
50