create database db;

create user u;

grant create, insert, select on db.t to u;

create sequence db.s;

select * from db.s;

--connect(con1,localhost,u,,db)

--error ER_TABLEACCESS_DENIED_ERROR

select nextval(s);

--error ER_TABLEACCESS_DENIED_ERROR

show create sequence s;

create table t (a int not null default(nextval(s)));

insert into t values (),();

select * from t;

select default(a) from t;

--disconnect con1

--connection default

select * from db.s;

drop database db;

drop user u;

connect con1,localhost,u,,db;

select nextval(s);

ERROR 42000: INSERT command denied to user 'u'@'localhost' for table `db`.`s`

show create sequence s;

ERROR 42000: SHOW command denied to user 'u'@'localhost' for table `db`.`s`

create table t (a int not null default(nextval(s)));

insert into t values (),();

select * from t;

a

1

2

select default(a) from t;

default(a)

3

4

disconnect con1;

create user u;

grant create, insert, select on db.t to u;

create table db.s (x int);

connect con1,localhost,u,,db;

create table t (a int not null default(nextval(s)));

ERROR 42S02: 'db.s' is not a SEQUENCE

create table t (a int not null default(nextval(s2)));

ERROR 42S02: Table 'db.s2' doesn't exist