diff --git ql/src/test/queries/clientpositive/authorization_9.q ql/src/test/queries/clientpositive/authorization_9.q index 1abe659..0b0ad7b 100644 --- ql/src/test/queries/clientpositive/authorization_9.q +++ ql/src/test/queries/clientpositive/authorization_9.q @@ -15,3 +15,11 @@ grant select on table dummy to user hive_test_user2; grant select (key, value) on table dummy to user hive_test_user2; show grant on all; + +revoke select on database default from user hive_test_user; +revoke select on table dummy from user hive_test_user; +revoke select (key, value) on table dummy from user hive_test_user; + +revoke select on database default from user hive_test_user2; +revoke select on table dummy from user hive_test_user2; +revoke select (key, value) on table dummy from user hive_test_user2; diff --git ql/src/test/results/clientpositive/authorization_9.q.out ql/src/test/results/clientpositive/authorization_9.q.out index 226ce28..d03682c 100644 --- ql/src/test/results/clientpositive/authorization_9.q.out +++ ql/src/test/results/clientpositive/authorization_9.q.out @@ -72,3 +72,35 @@ default dummy key hive_test_user USER Select false -1 hive_test_user default dummy key hive_test_user2 USER Select false -1 hive_test_user default dummy value hive_test_user USER Select false -1 hive_test_user default dummy value hive_test_user2 USER Select false -1 hive_test_user +PREHOOK: query: revoke select on database default from user hive_test_user +PREHOOK: type: REVOKE_PRIVILEGE +POSTHOOK: query: revoke select on database default from user hive_test_user +POSTHOOK: type: REVOKE_PRIVILEGE +PREHOOK: query: revoke select on table dummy from user hive_test_user +PREHOOK: type: REVOKE_PRIVILEGE +PREHOOK: Output: default@dummy +POSTHOOK: query: revoke select on table dummy from user hive_test_user +POSTHOOK: type: REVOKE_PRIVILEGE +POSTHOOK: Output: default@dummy +PREHOOK: query: revoke select (key, value) on table dummy from user hive_test_user +PREHOOK: type: REVOKE_PRIVILEGE +PREHOOK: Output: default@dummy +POSTHOOK: query: revoke select (key, value) on table dummy from user hive_test_user +POSTHOOK: type: REVOKE_PRIVILEGE +POSTHOOK: Output: default@dummy +PREHOOK: query: revoke select on database default from user hive_test_user2 +PREHOOK: type: REVOKE_PRIVILEGE +POSTHOOK: query: revoke select on database default from user hive_test_user2 +POSTHOOK: type: REVOKE_PRIVILEGE +PREHOOK: query: revoke select on table dummy from user hive_test_user2 +PREHOOK: type: REVOKE_PRIVILEGE +PREHOOK: Output: default@dummy +POSTHOOK: query: revoke select on table dummy from user hive_test_user2 +POSTHOOK: type: REVOKE_PRIVILEGE +POSTHOOK: Output: default@dummy +PREHOOK: query: revoke select (key, value) on table dummy from user hive_test_user2 +PREHOOK: type: REVOKE_PRIVILEGE +PREHOOK: Output: default@dummy +POSTHOOK: query: revoke select (key, value) on table dummy from user hive_test_user2 +POSTHOOK: type: REVOKE_PRIVILEGE +POSTHOOK: Output: default@dummy