diff options
Diffstat (limited to 'mysql-test/suite/sql_sequence/alter.test')
-rw-r--r-- | mysql-test/suite/sql_sequence/alter.test | 34 |
1 files changed, 0 insertions, 34 deletions
diff --git a/mysql-test/suite/sql_sequence/alter.test b/mysql-test/suite/sql_sequence/alter.test index a05a3e2e78b..fd1809ccd2f 100644 --- a/mysql-test/suite/sql_sequence/alter.test +++ b/mysql-test/suite/sql_sequence/alter.test @@ -139,37 +139,3 @@ select next value for t1; alter sequence t1 restart with 90; select next value for t1; drop sequence t1; - ---echo ---echo GRANT ---echo - -create database s_db; -create sequence s_db.s1; -grant select on s_db.s1 to normal_1@'%' identified by 'pass'; - -connect(m_normal_1, localhost, normal_1, pass, s_db); -select * from s1; ---error ER_TABLEACCESS_DENIED_ERROR -select nextval(s1); -show create sequence s1; ---error ER_TABLEACCESS_DENIED_ERROR -alter sequence s1 restart 50; -connection default; -grant insert on s_db.s1 to normal_1@'%'; -connection m_normal_1; -select nextval(s1); ---error ER_TABLEACCESS_DENIED_ERROR -alter sequence s1 restart 50; -connection default; -grant alter on s_db.s1 to normal_1@'%'; -connection m_normal_1; -alter sequence s1 restart 50; -select nextval(s1); ---error ER_TABLEACCESS_DENIED_ERROR -drop sequence s1; - -connection default; -disconnect m_normal_1; -drop database s_db; -drop user normal_1@'%'; |