ql/src/test/queries/clientpositive/authorization_update.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 hive.support.concurrency=true;
set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;


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

CREATE TABLE t_auth_up(i int, j int) clustered by (i) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true');

CREATE TABLE t_select_n0(i int);
GRANT ALL ON TABLE t_select_n0 TO ROLE public;

-- grant update privilege to another user
GRANT UPDATE ON t_auth_up TO USER userWIns;
GRANT SELECT ON t_auth_up TO USER userWIns;

set user.name=hive_admin_user;
set role admin;
SHOW GRANT ON TABLE t_auth_up;


set user.name=userWIns;
update t_auth_up set j = 0 where i > 0;