|
create user test@localhost;
|
grant select on test.* to test@localhost;
|
|
create table t1 (a int);
|
create definer=test@localhost sql security definer view v1 as select * from t1;
|
|
--echo # check that ot works without view
|
--eval select * INTO OUTFILE '$MYSQL_TMP_DIR/test_out_txt' from t1;
|
--echo # check that ot works without file
|
select * from v1;
|
|
--echo # rights for file should be taken from current user not view
|
--eval select * INTO OUTFILE '$MYSQL_TMP_DIR/test_out_txt' from (select count(*) from v1) as dv1;
|
--echo # rights for file should be taken from current user not view
|
--eval select * INTO OUTFILE '$MYSQL_TMP_DIR/test_out_txt' from (select * from v1) as dv1;
|
--eval select * INTO OUTFILE '$MYSQL_TMP_DIR/test_out_txt' from v1;
|
|
--remove_file $MYSQL_TMP_DIR/test_out_txt
|
drop view v1;
|
drop table t1;
|
drop user test@localhost;
|