| 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.security.authorization.enabled=true; |
| |
| set user.name=user_dbowner; |
| -- check ctas without db ownership |
| create database ctas_auth; |
| |
| set user.name=user_unauth; |
| create table t1(i int); |
| use ctas_auth; |
| show tables; |
| create table t2 as select * from default.t1; |