1--source include/have_innodb.inc 2--source include/not_embedded.inc 3 4set sql_mode=""; 5 6--echo # Test 7: Check privileges required. 7--echo # 8 9CREATE DATABASE db1; 10CREATE TABLE db1.t1 (a INT) engine= InnoDB; 11GRANT RELOAD, SELECT, LOCK TABLES ON *.* TO user1@localhost; 12GRANT CREATE, DROP ON *.* TO user2@localhost; 13GRANT RELOAD, SELECT ON *.* TO user3@localhost; 14GRANT SELECT, LOCK TABLES ON *.* TO user4@localhost; 15GRANT RELOAD, LOCK TABLES ON *.* TO user5@localhost; 16 17--connect(con1, localhost, user1) 18FLUSH TABLE db1.t1 FOR EXPORT; 19UNLOCK TABLES; 20--disconnect con1 21--source include/wait_until_disconnected.inc 22 23--connection default 24 25--connect(con1, localhost, user2) 26--error ER_SPECIFIC_ACCESS_DENIED_ERROR 27FLUSH TABLE db1.t1 FOR EXPORT; 28--disconnect con1 29--source include/wait_until_disconnected.inc 30 31--connection default 32 33--connect(con1, localhost, user3) 34--error ER_DBACCESS_DENIED_ERROR 35FLUSH TABLE db1.t1 FOR EXPORT; 36--disconnect con1 37--source include/wait_until_disconnected.inc 38 39--connection default 40 41--connect(con1, localhost, user4) 42--error ER_SPECIFIC_ACCESS_DENIED_ERROR 43FLUSH TABLE db1.t1 FOR EXPORT; 44--disconnect con1 45--source include/wait_until_disconnected.inc 46 47--connection default 48 49--connect(con1, localhost, user5) 50--error ER_TABLEACCESS_DENIED_ERROR 51FLUSH TABLE db1.t1 FOR EXPORT; 52--disconnect con1 53--source include/wait_until_disconnected.inc 54 55--connection default 56DROP USER user1@localhost, user2@localhost, user3@localhost, 57 user4@localhost, user5@localhost; 58DROP TABLE db1.t1; 59DROP DATABASE db1; 60 61--echo # End of 5.6 tests 62