ql/src/test/queries/clientnegative/authorization_revoke_table_fail2.q

set hive.test.authz.sstd.hs2.mode=true;
set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest;
set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator;

set user.name=user1;
-- current user has been set (comment line before the set cmd is resulting in parse error!!)

CREATE TABLE table_priv_rfai2(i int);

-- grant insert to user2
GRANT INSERT ON table_priv_rfai2 TO USER user2;
GRANT SELECT ON table_priv_rfai2 TO USER user3 WITH GRANT OPTION;

set user.name=user3;
-- grant select as user3 to user 2
GRANT SELECT ON table_priv_rfai2 TO USER user2;

-- try dropping the privilege as user3
REVOKE INSERT ON TABLE table_priv_rfai2 FROM USER user2;