Debian Codegraph @

mysql-test/suite/sql_sequence/alter_notembedded.result

raw
1 #
2 # GRANT
3 #
4 create database s_db;
5 create sequence s_db.s1;
6 grant select on s_db.s1 to normal_1@'%' identified by 'pass';
7 connect m_normal_1, localhost, normal_1, pass, s_db;
8 select * from s1;
9 next_not_cached_value minimum_value maximum_value start_value increment cache_size cycle_option cycle_count
10 1 1 9223372036854775806 1 1 1000 0 0
11 select nextval(s1);
12 ERROR 42000: INSERT command denied to user 'normal_1'@'localhost' for table `s_db`.`s1`
13 show create sequence s1;
14 Table Create Table
15 s1 CREATE SEQUENCE `s1` start with 1 minvalue 1 maxvalue 9223372036854775806 increment by 1 cache 1000 nocycle ENGINE=MyISAM
16 alter sequence s1 restart 50;
17 ERROR 42000: ALTER command denied to user 'normal_1'@'localhost' for table `s_db`.`s1`
18 connection default;
19 grant insert on s_db.s1 to normal_1@'%';
20 connection m_normal_1;
21 select nextval(s1);
22 nextval(s1)
23 1
24 alter sequence s1 restart 50;
25 ERROR 42000: ALTER command denied to user 'normal_1'@'localhost' for table `s_db`.`s1`
26 connection default;
27 grant alter on s_db.s1 to normal_1@'%';
28 connection m_normal_1;
29 alter sequence s1 restart 50;
30 select nextval(s1);
31 nextval(s1)
32 50
33 drop sequence s1;
34 ERROR 42000: DROP command denied to user 'normal_1'@'localhost' for table `s_db`.`s1`
35 connection default;
36 disconnect m_normal_1;
37 drop database s_db;
38 drop user normal_1@'%';