--source include/have_partition.inc

create database db;

create user u@localhost;

grant all on db.* to u@localhost;

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

create table t1 (a int) partition by range(a) (p1 values less than (100), p2 values less than (1000));

alter table t1 convert partition p2 to table tp;

alter table t1 convert table tp to partition p2 values less than (1000);

# Cleanup

--disconnect con1

--connection default

drop user u@localhost;

drop database db;

mysqltest: At line 10: query 'alter table t1 convert table tp to partition p2 values less than (1000)' failed: ER_TABLEACCESS_DENIED_ERROR (1142): DROP, ALTER command denied to user 'u'@'localhost' for table `db`.`tp`