Debian Codegraph @

mysql-test/suite/roles/roles_tables_priv-29465.test

raw
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;