summaryrefslogtreecommitdiff
path: root/mysql-test/suite/sql_sequence/alter.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/sql_sequence/alter.test')
-rw-r--r--mysql-test/suite/sql_sequence/alter.test34
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@'%';