| --! qt:authorizer |
| set user.name=hive_admin_user; |
| |
| create table src_autho_test (key STRING, value STRING) ; |
| |
| |
| --select dummy table |
| select 1; |
| |
| set role ADMIN; |
| --table grant to user |
| |
| grant select on table src_autho_test to user user_sauth; |
| |
| show grant user user_sauth on table src_autho_test; |
| |
| |
| revoke select on table src_autho_test from user user_sauth; |
| show grant user user_sauth on table src_autho_test; |
| |
| --role |
| create role src_role; |
| grant role src_role to user user_sauth; |
| show role grant user user_sauth; |
| |
| --table grant to role |
| |
| -- also verify case insesitive behavior of role name |
| grant select on table src_autho_test to role Src_ROle; |
| |
| show grant role src_role on table src_autho_test; |
| revoke select on table src_autho_test from role src_rolE; |
| |
| -- drop role |
| drop role SRc_role; |