| 1 |
--source include/not_embedded.inc |
| 2 |
|
| 3 |
create user foo; |
| 4 |
create database some_db; |
| 5 |
create table some_db.t1 (a int, b int, secret int); |
| 6 |
|
| 7 |
create role r_select_column; |
| 8 |
create role r_active_column; |
| 9 |
grant r_select_column to r_active_column; |
| 10 |
grant r_active_column to foo; |
| 11 |
|
| 12 |
grant select(a) on some_db.t1 to r_select_column; |
| 13 |
select * from mysql.tables_priv order by user; |
| 14 |
grant insert(a) on some_db.t1 to r_active_column; |
| 15 |
select * from mysql.tables_priv order by user; |
| 16 |
|
| 17 |
--connect (con1, localhost, foo,,) |
| 18 |
--error ER_TABLEACCESS_DENIED_ERROR |
| 19 |
insert into some_db.t1(a) values (1); |
| 20 |
set role r_active_column; |
| 21 |
insert into some_db.t1(a) values (1); |
| 22 |
disconnect con1; |
| 23 |
|
| 24 |
connection default; |
| 25 |
revoke insert(a) on some_db.t1 from r_active_column; |
| 26 |
|
| 27 |
--connect (con1, localhost, foo,,) |
| 28 |
--error ER_TABLEACCESS_DENIED_ERROR |
| 29 |
insert into some_db.t1(a) values (1); |
| 30 |
set role r_active_column; |
| 31 |
--error ER_TABLEACCESS_DENIED_ERROR |
| 32 |
insert into some_db.t1(a) values (1); |
| 33 |
disconnect con1; |
| 34 |
|
| 35 |
connection default; |
| 36 |
|
| 37 |
drop role r_select_column; |
| 38 |
drop role r_active_column; |
| 39 |
drop user foo; |
| 40 |
drop database some_db; |