--! qt:dataset:src
set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.DefaultHiveAuthorizationProvider;

-- SORT_BEFORE_DIFF

create table src_autho_test_n2 as select * from src;

grant All on table src_autho_test_n2 to user hive_test_user;

set hive.security.authorization.enabled=true;

show grant user hive_test_user on table src_autho_test_n2;

select key from src_autho_test_n2 order by key limit 20;

drop table src_autho_test_n2;