blob: 5cb9b24496f00b1162ea244946667947b295f5c4 [file] [log] [blame]
--! qt:dataset:src
set hive.cbo.enable=false;
set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.DefaultHiveAuthorizationProvider;
create table src_autho_test as select * from src;
create view v1 as select * from src_autho_test;
create view v2 as select * from v1;
set hive.security.authorization.enabled=true;
--table grant to user
grant select on table v2 to user hive_test_user;
--grant select(key) on table src_autho_test to user hive_test_user;
select v2.key from v2 join (select key from src_autho_test)subq on v2.value=subq.key order by key limit 10;