Added: hive/trunk/ql/src/test/results/clientnegative/authorization_revoke_table_fail2.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/authorization_revoke_table_fail2.q.out?rev=1566401&view=auto ============================================================================== --- hive/trunk/ql/src/test/results/clientnegative/authorization_revoke_table_fail2.q.out (added) +++ hive/trunk/ql/src/test/results/clientnegative/authorization_revoke_table_fail2.q.out Sun Feb 9 20:43:37 2014 @@ -0,0 +1,37 @@ +PREHOOK: query: -- current user has been set (comment line before the set cmd is resulting in parse error!!) + +CREATE TABLE table_priv_rfai2(i int) +PREHOOK: type: CREATETABLE +POSTHOOK: query: -- current user has been set (comment line before the set cmd is resulting in parse error!!) + +CREATE TABLE table_priv_rfai2(i int) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: default@table_priv_rfai2 +PREHOOK: query: -- grant insert to user2 +GRANT INSERT ON table_priv_rfai2 TO USER user2 +PREHOOK: type: GRANT_PRIVILEGE +PREHOOK: Output: default@table_priv_rfai2 +POSTHOOK: query: -- grant insert to user2 +GRANT INSERT ON table_priv_rfai2 TO USER user2 +POSTHOOK: type: GRANT_PRIVILEGE +POSTHOOK: Output: default@table_priv_rfai2 +PREHOOK: query: GRANT SELECT ON table_priv_rfai2 TO USER user3 WITH GRANT OPTION +PREHOOK: type: GRANT_PRIVILEGE +PREHOOK: Output: default@table_priv_rfai2 +POSTHOOK: query: GRANT SELECT ON table_priv_rfai2 TO USER user3 WITH GRANT OPTION +POSTHOOK: type: GRANT_PRIVILEGE +POSTHOOK: Output: default@table_priv_rfai2 +PREHOOK: query: -- grant select as user3 to user 2 +GRANT SELECT ON table_priv_rfai2 TO USER user2 +PREHOOK: type: GRANT_PRIVILEGE +PREHOOK: Output: default@table_priv_rfai2 +POSTHOOK: query: -- grant select as user3 to user 2 +GRANT SELECT ON table_priv_rfai2 TO USER user2 +POSTHOOK: type: GRANT_PRIVILEGE +POSTHOOK: Output: default@table_priv_rfai2 +PREHOOK: query: -- try dropping the privilege as user3 +REVOKE INSERT ON TABLE table_priv_rfai2 FROM USER user2 +PREHOOK: type: REVOKE_PRIVILEGE +PREHOOK: Output: default@table_priv_rfai2 +FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Cannot find privilege Privilege [name=INSERT, columns=null] for Principal [name=user2, type=USER] on Hive Object [type=TABLE, dbname=default, table/viewname=table_priv_rfai2] granted by user3 +
Modified: hive/trunk/ql/src/test/results/clientnegative/authorization_role_cycles1.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/authorization_role_cycles1.q.out?rev=1566401&r1=1566400&r2=1566401&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientnegative/authorization_role_cycles1.q.out (original) +++ hive/trunk/ql/src/test/results/clientnegative/authorization_role_cycles1.q.out Sun Feb 9 20:43:37 2014 @@ -15,4 +15,4 @@ POSTHOOK: type: GRANT_ROLE PREHOOK: query: -- this will create a cycle grant role role2 to role role1 PREHOOK: type: GRANT_ROLE -FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. org.apache.hadoop.hive.ql.security.authorization.plugin.HiveAuthorizationPluginException: Cannot grant role role1 to role2 as role2 already belongs to the role role1. (no cycles allowed) +FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. org.apache.hadoop.hive.ql.security.authorization.plugin.HiveAuthzPluginException: Cannot grant role role1 to role2 as role2 already belongs to the role role1. (no cycles allowed) Modified: hive/trunk/ql/src/test/results/clientnegative/authorization_role_cycles2.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/authorization_role_cycles2.q.out?rev=1566401&r1=1566400&r2=1566401&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientnegative/authorization_role_cycles2.q.out (original) +++ hive/trunk/ql/src/test/results/clientnegative/authorization_role_cycles2.q.out Sun Feb 9 20:43:37 2014 @@ -41,4 +41,4 @@ POSTHOOK: type: GRANT_ROLE PREHOOK: query: -- this will create a cycle in middle of the hierarchy grant role role2 to role role4 PREHOOK: type: GRANT_ROLE -FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. org.apache.hadoop.hive.ql.security.authorization.plugin.HiveAuthorizationPluginException: Cannot grant role role4 to role2 as role2 already belongs to the role role4. (no cycles allowed) +FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. org.apache.hadoop.hive.ql.security.authorization.plugin.HiveAuthzPluginException: Cannot grant role role4 to role2 as role2 already belongs to the role role4. (no cycles allowed) Modified: hive/trunk/ql/src/test/results/clientpositive/authorization_1_sql_std.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/authorization_1_sql_std.q.out?rev=1566401&r1=1566400&r2=1566401&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/authorization_1_sql_std.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/authorization_1_sql_std.q.out Sun Feb 9 20:43:37 2014 @@ -5,28 +5,28 @@ POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@src_autho_test PREHOOK: query: --table grant to user -grant select on table src_autho_test to user hive_test_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 hive_test_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 hive_test_user on table src_autho_test +PREHOOK: query: show grant user user_sauth on table src_autho_test PREHOOK: type: SHOW_GRANT -POSTHOOK: query: show grant user hive_test_user on table src_autho_test +POSTHOOK: query: show grant user user_sauth on table src_autho_test POSTHOOK: type: SHOW_GRANT -default src_autho_test hive_test_user USER Select false -1 hive_test_user -PREHOOK: query: revoke select on table src_autho_test from user hive_test_user +default src_autho_test user_sauth USER SELECT false -1 hive_test_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 hive_test_user +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 hive_test_user on table src_autho_test +PREHOOK: query: show grant user user_sauth on table src_autho_test PREHOOK: type: SHOW_GRANT -POSTHOOK: query: show grant user hive_test_user on table src_autho_test +POSTHOOK: query: show grant user user_sauth on table src_autho_test POSTHOOK: type: SHOW_GRANT PREHOOK: query: --role create role src_role @@ -34,15 +34,15 @@ PREHOOK: type: CREATEROLE POSTHOOK: query: --role create role src_role POSTHOOK: type: CREATEROLE -PREHOOK: query: grant role src_role to user hive_test_user +PREHOOK: query: grant role src_role to user user_sauth PREHOOK: type: GRANT_ROLE -POSTHOOK: query: grant role src_role to user hive_test_user +POSTHOOK: query: grant role src_role to user user_sauth POSTHOOK: type: GRANT_ROLE -PREHOOK: query: show role grant user hive_test_user +PREHOOK: query: show role grant user user_sauth PREHOOK: type: SHOW_ROLE_GRANT -POSTHOOK: query: show role grant user hive_test_user +POSTHOOK: query: show role grant user user_sauth POSTHOOK: type: SHOW_ROLE_GRANT -src_role -1 hive_test_user USER false -1 hive_test_user +src_role -1 user_sauth USER false -1 hive_test_user PUBLIC -1 false -1 PREHOOK: query: --table grant to role @@ -58,7 +58,7 @@ PREHOOK: query: show grant role src_role 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_test_user +default src_autho_test src_role ROLE SELECT false -1 hive_test_user PREHOOK: query: revoke select on table src_autho_test from role src_role PREHOOK: type: REVOKE_PRIVILEGE PREHOOK: Output: default@src_autho_test Added: hive/trunk/ql/src/test/results/clientpositive/authorization_create_table_owner_privs.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/authorization_create_table_owner_privs.q.out?rev=1566401&view=auto ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/authorization_create_table_owner_privs.q.out (added) +++ hive/trunk/ql/src/test/results/clientpositive/authorization_create_table_owner_privs.q.out Sun Feb 9 20:43:37 2014 @@ -0,0 +1,17 @@ +PREHOOK: query: create table create_table_creator_priv_test(i int) +PREHOOK: type: CREATETABLE +POSTHOOK: query: create table create_table_creator_priv_test(i int) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: default@create_table_creator_priv_test +PREHOOK: query: -- all privileges should have been set for user + +show grant user user1 on table create_table_creator_priv_test +PREHOOK: type: SHOW_GRANT +POSTHOOK: query: -- all privileges should have been set for user + +show grant user user1 on table create_table_creator_priv_test +POSTHOOK: type: SHOW_GRANT +default create_table_creator_priv_test user1 USER DELETE true -1 user1 +default create_table_creator_priv_test user1 USER INSERT true -1 user1 +default create_table_creator_priv_test user1 USER SELECT true -1 user1 +default create_table_creator_priv_test user1 USER UPDATE true -1 user1 Added: hive/trunk/ql/src/test/results/clientpositive/authorization_grant_table_priv.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/authorization_grant_table_priv.q.out?rev=1566401&view=auto ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/authorization_grant_table_priv.q.out (added) +++ hive/trunk/ql/src/test/results/clientpositive/authorization_grant_table_priv.q.out Sun Feb 9 20:43:37 2014 @@ -0,0 +1,106 @@ +PREHOOK: query: -- current user has been set (comment line before the set cmd is resulting in parse error!!) + +CREATE TABLE table_priv1(i int) +PREHOOK: type: CREATETABLE +POSTHOOK: query: -- current user has been set (comment line before the set cmd is resulting in parse error!!) + +CREATE TABLE table_priv1(i int) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: default@table_priv1 +PREHOOK: query: -- all privileges should have been set for user + +-- grant insert privilege to another user +GRANT INSERT ON table_priv1 TO USER user2 +PREHOOK: type: GRANT_PRIVILEGE +PREHOOK: Output: default@table_priv1 +POSTHOOK: query: -- all privileges should have been set for user + +-- grant insert privilege to another user +GRANT INSERT ON table_priv1 TO USER user2 +POSTHOOK: type: GRANT_PRIVILEGE +POSTHOOK: Output: default@table_priv1 +PREHOOK: query: SHOW GRANT USER user2 ON TABLE table_priv1 +PREHOOK: type: SHOW_GRANT +POSTHOOK: query: SHOW GRANT USER user2 ON TABLE table_priv1 +POSTHOOK: type: SHOW_GRANT +default table_priv1 user2 USER INSERT false -1 user1 +PREHOOK: query: -- grant select privilege to another user with grant +GRANT SELECT ON table_priv1 TO USER user2 with grant option +PREHOOK: type: GRANT_PRIVILEGE +PREHOOK: Output: default@table_priv1 +POSTHOOK: query: -- grant select privilege to another user with grant +GRANT SELECT ON table_priv1 TO USER user2 with grant option +POSTHOOK: type: GRANT_PRIVILEGE +POSTHOOK: Output: default@table_priv1 +PREHOOK: query: SHOW GRANT USER user2 ON TABLE table_priv1 +PREHOOK: type: SHOW_GRANT +POSTHOOK: query: SHOW GRANT USER user2 ON TABLE table_priv1 +POSTHOOK: type: SHOW_GRANT +default table_priv1 user2 USER INSERT false -1 user1 +default table_priv1 user2 USER SELECT true -1 user1 +PREHOOK: query: -- change to other user - user2 +-- grant permissions to another user as user2 +GRANT SELECT ON table_priv1 TO USER user3 with grant option +PREHOOK: type: GRANT_PRIVILEGE +PREHOOK: Output: default@table_priv1 +POSTHOOK: query: -- change to other user - user2 +-- grant permissions to another user as user2 +GRANT SELECT ON table_priv1 TO USER user3 with grant option +POSTHOOK: type: GRANT_PRIVILEGE +POSTHOOK: Output: default@table_priv1 +PREHOOK: query: SHOW GRANT USER user3 ON TABLE table_priv1 +PREHOOK: type: SHOW_GRANT +POSTHOOK: query: SHOW GRANT USER user3 ON TABLE table_priv1 +POSTHOOK: type: SHOW_GRANT +default table_priv1 user3 USER SELECT true -1 user2 +PREHOOK: query: -- change to other user - user3 +-- grant permissions to another user as user3 +GRANT SELECT ON table_priv1 TO USER user4 with grant option +PREHOOK: type: GRANT_PRIVILEGE +PREHOOK: Output: default@table_priv1 +POSTHOOK: query: -- change to other user - user3 +-- grant permissions to another user as user3 +GRANT SELECT ON table_priv1 TO USER user4 with grant option +POSTHOOK: type: GRANT_PRIVILEGE +POSTHOOK: Output: default@table_priv1 +PREHOOK: query: SHOW GRANT USER user4 ON TABLE table_priv1 +PREHOOK: type: SHOW_GRANT +POSTHOOK: query: SHOW GRANT USER user4 ON TABLE table_priv1 +POSTHOOK: type: SHOW_GRANT +default table_priv1 user4 USER SELECT true -1 user3 +#### A masked pattern was here #### + +-- grant all with grant to user22 +GRANT ALL ON table_priv1 TO USER user22 with grant option +PREHOOK: type: GRANT_PRIVILEGE +PREHOOK: Output: default@table_priv1 +#### A masked pattern was here #### + +-- grant all with grant to user22 +GRANT ALL ON table_priv1 TO USER user22 with grant option +POSTHOOK: type: GRANT_PRIVILEGE +POSTHOOK: Output: default@table_priv1 +PREHOOK: query: SHOW GRANT USER user22 ON TABLE table_priv1 +PREHOOK: type: SHOW_GRANT +POSTHOOK: query: SHOW GRANT USER user22 ON TABLE table_priv1 +POSTHOOK: type: SHOW_GRANT +default table_priv1 user22 USER DELETE true -1 user1 +default table_priv1 user22 USER INSERT true -1 user1 +default table_priv1 user22 USER SELECT true -1 user1 +default table_priv1 user22 USER UPDATE true -1 user1 +PREHOOK: query: -- grant all without grant to user33 +GRANT ALL ON table_priv1 TO USER user33 with grant option +PREHOOK: type: GRANT_PRIVILEGE +PREHOOK: Output: default@table_priv1 +POSTHOOK: query: -- grant all without grant to user33 +GRANT ALL ON table_priv1 TO USER user33 with grant option +POSTHOOK: type: GRANT_PRIVILEGE +POSTHOOK: Output: default@table_priv1 +PREHOOK: query: SHOW GRANT USER user33 ON TABLE table_priv1 +PREHOOK: type: SHOW_GRANT +POSTHOOK: query: SHOW GRANT USER user33 ON TABLE table_priv1 +POSTHOOK: type: SHOW_GRANT +default table_priv1 user33 USER DELETE true -1 user22 +default table_priv1 user33 USER INSERT true -1 user22 +default table_priv1 user33 USER SELECT true -1 user22 +default table_priv1 user33 USER UPDATE true -1 user22 Added: hive/trunk/ql/src/test/results/clientpositive/authorization_revoke_table_priv.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/authorization_revoke_table_priv.q.out?rev=1566401&view=auto ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/authorization_revoke_table_priv.q.out (added) +++ hive/trunk/ql/src/test/results/clientpositive/authorization_revoke_table_priv.q.out Sun Feb 9 20:43:37 2014 @@ -0,0 +1,150 @@ +PREHOOK: query: -- current user has been set (comment line before the set cmd is resulting in parse error!!) + +CREATE TABLE table_priv_rev(i int) +PREHOOK: type: CREATETABLE +POSTHOOK: query: -- current user has been set (comment line before the set cmd is resulting in parse error!!) + +CREATE TABLE table_priv_rev(i int) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: default@table_priv_rev +PREHOOK: query: -- grant insert privilege to user2 +GRANT INSERT ON table_priv_rev TO USER user2 +PREHOOK: type: GRANT_PRIVILEGE +PREHOOK: Output: default@table_priv_rev +POSTHOOK: query: -- grant insert privilege to user2 +GRANT INSERT ON table_priv_rev TO USER user2 +POSTHOOK: type: GRANT_PRIVILEGE +POSTHOOK: Output: default@table_priv_rev +PREHOOK: query: SHOW GRANT USER user2 ON TABLE table_priv_rev +PREHOOK: type: SHOW_GRANT +POSTHOOK: query: SHOW GRANT USER user2 ON TABLE table_priv_rev +POSTHOOK: type: SHOW_GRANT +default table_priv_rev user2 USER INSERT false -1 user1 +PREHOOK: query: -- revoke insert privilege from user2 +REVOKE INSERT ON TABLE table_priv_rev FROM USER user2 +PREHOOK: type: REVOKE_PRIVILEGE +PREHOOK: Output: default@table_priv_rev +POSTHOOK: query: -- revoke insert privilege from user2 +REVOKE INSERT ON TABLE table_priv_rev FROM USER user2 +POSTHOOK: type: REVOKE_PRIVILEGE +POSTHOOK: Output: default@table_priv_rev +PREHOOK: query: SHOW GRANT USER user2 ON TABLE table_priv_rev +PREHOOK: type: SHOW_GRANT +POSTHOOK: query: SHOW GRANT USER user2 ON TABLE table_priv_rev +POSTHOOK: type: SHOW_GRANT +PREHOOK: query: -- grant all privileges one at a time -- +-- grant insert privilege to user2 +GRANT INSERT ON table_priv_rev TO USER user2 +PREHOOK: type: GRANT_PRIVILEGE +PREHOOK: Output: default@table_priv_rev +POSTHOOK: query: -- grant all privileges one at a time -- +-- grant insert privilege to user2 +GRANT INSERT ON table_priv_rev TO USER user2 +POSTHOOK: type: GRANT_PRIVILEGE +POSTHOOK: Output: default@table_priv_rev +PREHOOK: query: SHOW GRANT USER user2 ON TABLE table_priv_rev +PREHOOK: type: SHOW_GRANT +POSTHOOK: query: SHOW GRANT USER user2 ON TABLE table_priv_rev +POSTHOOK: type: SHOW_GRANT +default table_priv_rev user2 USER INSERT false -1 user1 +PREHOOK: query: -- grant select privilege to user2, with grant option +GRANT SELECT ON table_priv_rev TO USER user2 WITH GRANT OPTION +PREHOOK: type: GRANT_PRIVILEGE +PREHOOK: Output: default@table_priv_rev +POSTHOOK: query: -- grant select privilege to user2, with grant option +GRANT SELECT ON table_priv_rev TO USER user2 WITH GRANT OPTION +POSTHOOK: type: GRANT_PRIVILEGE +POSTHOOK: Output: default@table_priv_rev +PREHOOK: query: SHOW GRANT USER user2 ON TABLE table_priv_rev +PREHOOK: type: SHOW_GRANT +POSTHOOK: query: SHOW GRANT USER user2 ON TABLE table_priv_rev +POSTHOOK: type: SHOW_GRANT +default table_priv_rev user2 USER INSERT false -1 user1 +default table_priv_rev user2 USER SELECT true -1 user1 +PREHOOK: query: -- grant update privilege to user2 +GRANT UPDATE ON table_priv_rev TO USER user2 +PREHOOK: type: GRANT_PRIVILEGE +PREHOOK: Output: default@table_priv_rev +POSTHOOK: query: -- grant update privilege to user2 +GRANT UPDATE ON table_priv_rev TO USER user2 +POSTHOOK: type: GRANT_PRIVILEGE +POSTHOOK: Output: default@table_priv_rev +PREHOOK: query: SHOW GRANT USER user2 ON TABLE table_priv_rev +PREHOOK: type: SHOW_GRANT +POSTHOOK: query: SHOW GRANT USER user2 ON TABLE table_priv_rev +POSTHOOK: type: SHOW_GRANT +default table_priv_rev user2 USER INSERT false -1 user1 +default table_priv_rev user2 USER UPDATE false -1 user1 +default table_priv_rev user2 USER SELECT true -1 user1 +PREHOOK: query: -- grant delete privilege to user2 +GRANT DELETE ON table_priv_rev TO USER user2 +PREHOOK: type: GRANT_PRIVILEGE +PREHOOK: Output: default@table_priv_rev +POSTHOOK: query: -- grant delete privilege to user2 +GRANT DELETE ON table_priv_rev TO USER user2 +POSTHOOK: type: GRANT_PRIVILEGE +POSTHOOK: Output: default@table_priv_rev +PREHOOK: query: SHOW GRANT USER user2 ON TABLE table_priv_rev +PREHOOK: type: SHOW_GRANT +POSTHOOK: query: SHOW GRANT USER user2 ON TABLE table_priv_rev +POSTHOOK: type: SHOW_GRANT +default table_priv_rev user2 USER DELETE false -1 user1 +default table_priv_rev user2 USER INSERT false -1 user1 +default table_priv_rev user2 USER UPDATE false -1 user1 +default table_priv_rev user2 USER SELECT true -1 user1 +PREHOOK: query: -- start revoking -- +-- revoke update privilege from user2 +REVOKE UPDATE ON TABLE table_priv_rev FROM USER user2 +PREHOOK: type: REVOKE_PRIVILEGE +PREHOOK: Output: default@table_priv_rev +POSTHOOK: query: -- start revoking -- +-- revoke update privilege from user2 +REVOKE UPDATE ON TABLE table_priv_rev FROM USER user2 +POSTHOOK: type: REVOKE_PRIVILEGE +POSTHOOK: Output: default@table_priv_rev +PREHOOK: query: SHOW GRANT USER user2 ON TABLE table_priv_rev +PREHOOK: type: SHOW_GRANT +POSTHOOK: query: SHOW GRANT USER user2 ON TABLE table_priv_rev +POSTHOOK: type: SHOW_GRANT +default table_priv_rev user2 USER DELETE false -1 user1 +default table_priv_rev user2 USER INSERT false -1 user1 +default table_priv_rev user2 USER SELECT true -1 user1 +PREHOOK: query: -- revoke DELETE privilege from user2 +REVOKE DELETE ON TABLE table_priv_rev FROM USER user2 +PREHOOK: type: REVOKE_PRIVILEGE +PREHOOK: Output: default@table_priv_rev +POSTHOOK: query: -- revoke DELETE privilege from user2 +REVOKE DELETE ON TABLE table_priv_rev FROM USER user2 +POSTHOOK: type: REVOKE_PRIVILEGE +POSTHOOK: Output: default@table_priv_rev +PREHOOK: query: SHOW GRANT USER user2 ON TABLE table_priv_rev +PREHOOK: type: SHOW_GRANT +POSTHOOK: query: SHOW GRANT USER user2 ON TABLE table_priv_rev +POSTHOOK: type: SHOW_GRANT +default table_priv_rev user2 USER INSERT false -1 user1 +default table_priv_rev user2 USER SELECT true -1 user1 +PREHOOK: query: -- revoke insert privilege from user2 +REVOKE INSERT ON TABLE table_priv_rev FROM USER user2 +PREHOOK: type: REVOKE_PRIVILEGE +PREHOOK: Output: default@table_priv_rev +POSTHOOK: query: -- revoke insert privilege from user2 +REVOKE INSERT ON TABLE table_priv_rev FROM USER user2 +POSTHOOK: type: REVOKE_PRIVILEGE +POSTHOOK: Output: default@table_priv_rev +PREHOOK: query: SHOW GRANT USER user2 ON TABLE table_priv_rev +PREHOOK: type: SHOW_GRANT +POSTHOOK: query: SHOW GRANT USER user2 ON TABLE table_priv_rev +POSTHOOK: type: SHOW_GRANT +default table_priv_rev user2 USER SELECT true -1 user1 +PREHOOK: query: -- revoke select privilege from user2 +REVOKE SELECT ON TABLE table_priv_rev FROM USER user2 +PREHOOK: type: REVOKE_PRIVILEGE +PREHOOK: Output: default@table_priv_rev +POSTHOOK: query: -- revoke select privilege from user2 +REVOKE SELECT ON TABLE table_priv_rev FROM USER user2 +POSTHOOK: type: REVOKE_PRIVILEGE +POSTHOOK: Output: default@table_priv_rev +PREHOOK: query: SHOW GRANT USER user2 ON TABLE table_priv_rev +PREHOOK: type: SHOW_GRANT +POSTHOOK: query: SHOW GRANT USER user2 ON TABLE table_priv_rev +POSTHOOK: type: SHOW_GRANT
