mirror of
https://github.com/MariaDB/server.git
synced 2025-11-04 12:56:14 +01:00
1f51d6c0f6
- Added missing information about database of corresponding table for various types of commands - Update some typos - Reviewed by: <vicentiu@mariadb.org>
38 lines
1.3 KiB
Text
38 lines
1.3 KiB
Text
#
|
|
# GRANT
|
|
#
|
|
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;
|
|
next_not_cached_value minimum_value maximum_value start_value increment cache_size cycle_option cycle_count
|
|
1 1 9223372036854775806 1 1 1000 0 0
|
|
select nextval(s1);
|
|
ERROR 42000: INSERT command denied to user 'normal_1'@'localhost' for table `s_db`.`s1`
|
|
show create sequence s1;
|
|
Table Create Table
|
|
s1 CREATE SEQUENCE `s1` start with 1 minvalue 1 maxvalue 9223372036854775806 increment by 1 cache 1000 nocycle ENGINE=MyISAM
|
|
alter sequence s1 restart 50;
|
|
ERROR 42000: ALTER command denied to user 'normal_1'@'localhost' for table `s_db`.`s1`
|
|
connection default;
|
|
grant insert on s_db.s1 to normal_1@'%';
|
|
connection m_normal_1;
|
|
select nextval(s1);
|
|
nextval(s1)
|
|
1
|
|
alter sequence s1 restart 50;
|
|
ERROR 42000: ALTER command denied to user 'normal_1'@'localhost' for table `s_db`.`s1`
|
|
connection default;
|
|
grant alter on s_db.s1 to normal_1@'%';
|
|
connection m_normal_1;
|
|
alter sequence s1 restart 50;
|
|
select nextval(s1);
|
|
nextval(s1)
|
|
50
|
|
drop sequence s1;
|
|
ERROR 42000: DROP command denied to user 'normal_1'@'localhost' for table `s_db`.`s1`
|
|
connection default;
|
|
disconnect m_normal_1;
|
|
drop database s_db;
|
|
drop user normal_1@'%';
|