| 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 tauth_gdup(i int); |
| |
| -- It should be possible to revert owners privileges |
| revoke SELECT ON tauth_gdup from user user1; |
| |
| show grant user user1 on table tauth_gdup; |
| |
| -- Owner already has all privileges granted, another grant would become duplicate |
| -- and result in error |
| GRANT INSERT ON tauth_gdup TO USER user1; |