diff options
author | Sergei Golubchik <serg@mariadb.org> | 2017-10-05 22:10:38 +0200 |
---|---|---|
committer | Sergei Golubchik <serg@mariadb.org> | 2017-10-06 12:28:56 +0200 |
commit | 2d2f857fb371ada237bad3fb2f470c613cdf5da2 (patch) | |
tree | b4771169e7266360a28e994cf15b0097310050bc /mysql-test/suite/sql_sequence/alter.test | |
parent | e59d080ffa233edeffdfe860444874e748289563 (diff) | |
download | mariadb-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.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@'%'; |