1# Grant tests not performed with embedded server
2-- source include/not_embedded.inc
3
4##TEST for invisible coloumn level 2
5create user user_1;
6show grants for user_1;
7--echo # create user
8create database d;
9use d;
10
11--echo
12--echo #System_Invisible
13create table t1(a int) with system versioning;
14insert into t1 values(1);
15select a from t1;
16select count(row_start) from t1;
17grant insert(a) on t1 to user_1;
18grant update(a) on t1 to user_1;
19grant select(a) on t1 to user_1;
20grant delete on t1 to user_1;
21connect (con1, localhost, user_1,,test);
22connection con1;
23select user();
24use d;
25select * from t1;
26insert into t1 values(2);
27select * from t1;
28insert into t1(a) values(3);
29select * from t1;
30select a from t1;
31select count(row_start) from t1;
32delete from t1 where a =1;
33update t1 set a=1 where a=3;
34select * from t1;
35connection default;
36REVOKE ALL PRIVILEGES, GRANT OPTION FROM user_1;
37
38connection con1;
39--error ER_TABLEACCESS_DENIED_ERROR
40select * from t1;
41--error ER_TABLEACCESS_DENIED_ERROR
42select count(row_start) from t1;
43
44disconnect con1;
45--source include/wait_until_disconnected.inc
46
47--echo
48--echo #Cleanup
49--source include/wait_until_disconnected.inc
50connection default;
51drop user user_1;
52drop database d;
53