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

create database authorization_9;
use authorization_9;

create table dummy_n1 (key string, value string);

grant select to user hive_test_user;
grant select on database authorization_9 to user hive_test_user;
grant select on table dummy_n1 to user hive_test_user;
grant select (key, value) on table dummy_n1 to user hive_test_user;

show grant user hive_test_user on database authorization_9;
show grant user hive_test_user on table dummy_n1;
show grant user hive_test_user on all;

grant select to user hive_test_user2;
grant select on database authorization_9 to user hive_test_user2;
grant select on table dummy_n1 to user hive_test_user2;
grant select (key, value) on table dummy_n1 to user hive_test_user2;

show grant on all;
show grant user hive_test_user on all;
show grant user hive_test_user2 on all;

revoke select from user hive_test_user;
revoke select on database authorization_9 from user hive_test_user;
revoke select on table dummy_n1 from user hive_test_user;
revoke select (key, value) on table dummy_n1 from user hive_test_user;

revoke select from user hive_test_user2;
revoke select on database authorization_9 from user hive_test_user2;
revoke select on table dummy_n1 from user hive_test_user2;
revoke select (key, value) on table dummy_n1 from user hive_test_user2;