| 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=hive_admin_user; |
| |
| -- enable sql standard authorization |
| -- role granting without role keyword |
| -- also test role being treated as case insensitive |
| set role ADMIN; |
| create role src_Role2; |
| |
| grant SRC_role2 to user user2 ; |
| show role grant user user2; |
| show roles; |
| |
| -- revoke role without role keyword |
| revoke src_rolE2 from user user2; |
| show role grant user user2; |
| show roles; |
| |
| ---------------------------------------- |
| -- role granting without role keyword, with admin option (syntax check) |
| ---------------------------------------- |
| |
| create role src_role_wadmin; |
| grant src_role_wadmin to user user2 with admin option; |
| show role grant user user2; |
| |
| -- revoke admin option |
| revoke admin option for src_role_wadmin from user user2; |
| show role grant user user2; |
| |
| -- revoke role without role keyword |
| revoke src_role_wadmin from user user2; |
| show role grant user user2; |
| |
| -- drop roles |
| show roles; |
| drop role Src_role2; |
| show roles; |
| drop role sRc_role_wadmin; |
| show roles; |