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