PREHOOK: query: create table src_autho_test (key STRING, value STRING)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@src_autho_test
POSTHOOK: query: create table src_autho_test (key STRING, value STRING)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@src_autho_test
PREHOOK: query: set  role ADMIN
PREHOOK: type: SHOW_ROLES
POSTHOOK: query: set  role ADMIN
POSTHOOK: type: SHOW_ROLES
PREHOOK: query: --table grant to user

grant select on table src_autho_test to user user_sauth
PREHOOK: type: GRANT_PRIVILEGE
PREHOOK: Output: default@src_autho_test
POSTHOOK: query: --table grant to user

grant select on table src_autho_test to user user_sauth
POSTHOOK: type: GRANT_PRIVILEGE
POSTHOOK: Output: default@src_autho_test
PREHOOK: query: show grant user user_sauth on table src_autho_test
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant user user_sauth on table src_autho_test
POSTHOOK: type: SHOW_GRANT
default	src_autho_test			user_sauth	USER	SELECT	false	-1	hive_admin_user
PREHOOK: query: revoke select on table src_autho_test from user user_sauth
PREHOOK: type: REVOKE_PRIVILEGE
PREHOOK: Output: default@src_autho_test
POSTHOOK: query: revoke select on table src_autho_test from user user_sauth
POSTHOOK: type: REVOKE_PRIVILEGE
POSTHOOK: Output: default@src_autho_test
PREHOOK: query: show grant user user_sauth on table src_autho_test
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant user user_sauth on table src_autho_test
POSTHOOK: type: SHOW_GRANT
PREHOOK: query: --role
create role src_role
PREHOOK: type: CREATEROLE
POSTHOOK: query: --role
create role src_role
POSTHOOK: type: CREATEROLE
PREHOOK: query: grant role src_role to user user_sauth
PREHOOK: type: GRANT_ROLE
POSTHOOK: query: grant role src_role to user user_sauth
POSTHOOK: type: GRANT_ROLE
PREHOOK: query: show role grant user user_sauth
PREHOOK: type: SHOW_ROLE_GRANT
POSTHOOK: query: show role grant user user_sauth
POSTHOOK: type: SHOW_ROLE_GRANT
public	false	-1	
src_role	false	-1	hive_admin_user
PREHOOK: query: --table grant to role

-- also verify case insesitive behavior of role name
grant select on table src_autho_test to role Src_ROle
PREHOOK: type: GRANT_PRIVILEGE
PREHOOK: Output: default@src_autho_test
POSTHOOK: query: --table grant to role

-- also verify case insesitive behavior of role name
grant select on table src_autho_test to role Src_ROle
POSTHOOK: type: GRANT_PRIVILEGE
POSTHOOK: Output: default@src_autho_test
PREHOOK: query: show grant role src_role on table src_autho_test
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant role src_role on table src_autho_test
POSTHOOK: type: SHOW_GRANT
default	src_autho_test			src_role	ROLE	SELECT	false	-1	hive_admin_user
PREHOOK: query: revoke select on table src_autho_test from role src_rolE
PREHOOK: type: REVOKE_PRIVILEGE
PREHOOK: Output: default@src_autho_test
POSTHOOK: query: revoke select on table src_autho_test from role src_rolE
POSTHOOK: type: REVOKE_PRIVILEGE
POSTHOOK: Output: default@src_autho_test
PREHOOK: query: -- drop role
drop role SRc_role
PREHOOK: type: DROPROLE
POSTHOOK: query: -- drop role
drop role SRc_role
POSTHOOK: type: DROPROLE
PREHOOK: query: drop table src_autho_test
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@src_autho_test
PREHOOK: Output: default@src_autho_test
POSTHOOK: query: drop table src_autho_test
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@src_autho_test
POSTHOOK: Output: default@src_autho_test