summaryrefslogtreecommitdiff
path: root/mysql-test/suite/sql_sequence/alter.test
diff options
context:
space:
mode:
authorSergei Golubchik <serg@mariadb.org>2017-10-05 22:10:38 +0200
committerSergei Golubchik <serg@mariadb.org>2017-10-06 12:28:56 +0200
commit2d2f857fb371ada237bad3fb2f470c613cdf5da2 (patch)
treeb4771169e7266360a28e994cf15b0097310050bc /mysql-test/suite/sql_sequence/alter.test
parente59d080ffa233edeffdfe860444874e748289563 (diff)
downloadmariadb-git-mariadb-10.3.2.tar.gz
fixes for --embeddedmariadb-10.3.2
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@'%';