| --! qt:dataset:src |
| set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.DefaultHiveAuthorizationProvider; |
| |
| -- SORT_BEFORE_DIFF |
| |
| create table src_autho_test_n5 as select * from src; |
| |
| grant drop on table src_autho_test_n5 to user hive_test_user; |
| grant select on table src_autho_test_n5 to user hive_test_user; |
| |
| show grant user hive_test_user on table src_autho_test_n5; |
| |
| revoke select on table src_autho_test_n5 from user hive_test_user; |
| revoke drop on table src_autho_test_n5 from user hive_test_user; |
| |
| grant drop,select on table src_autho_test_n5 to user hive_test_user; |
| show grant user hive_test_user on table src_autho_test_n5; |
| revoke drop,select on table src_autho_test_n5 from user hive_test_user; |
| |
| grant drop,select(key), select(value) on table src_autho_test_n5 to user hive_test_user; |
| show grant user hive_test_user on table src_autho_test_n5; |
| revoke drop,select(key), select(value) on table src_autho_test_n5 from user hive_test_user; |