...
-hiveconf hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactory
-hiveconf hive.security.authorization.enabled=true
-hiveconf hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateUserAuthenticator.
-hiveconf hive.metastore.uris=' '
Known Issues
HIVE-6985 - sql std auth - privileges grants to public role not being honored
HIVE-6919 - Hive sql std auth select query fails on partitioned tables
HIVE-6921 - Index creation fails with sql std auth turned on
HIVE-6957 - SQL authorization does not work with HS2 binary mode and Kerberos auth
References
For information on the SQL standard for security see:
...