ql/src/test/queries/clientpositive/authorization_grant_public_role.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  t_gpr1(i int);

-- all privileges should have been set for user

GRANT ALL ON t_gpr1 TO ROLE pubLic;

SHOW GRANT USER user1 ON TABLE t_gpr1;
SHOW GRANT ROLE pubLic ON TABLE t_gpr1;

set user.name=user2;
SHOW CURRENT ROLES;
-- user2 should be able to do a describe table, as pubic is in the current roles
DESC t_gpr1;