[ https://issues.apache.org/jira/browse/HIVE-19747?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16496995#comment-16496995 ]
Rajkumar Singh commented on HIVE-19747: --------------------------------------- it seems that you are missing the object in the command on which you want to grant privileges. the command should be like this {code} grant all on database `default` to user abc; {code} > "GRANT ALL TO USER" failed with NullPointerException > ---------------------------------------------------- > > Key: HIVE-19747 > URL: https://issues.apache.org/jira/browse/HIVE-19747 > Project: Hive > Issue Type: Bug > Components: Authorization > Affects Versions: 2.1.0 > Reporter: Aihua Xu > Priority: Minor > > If you issue the command 'grant all to user abc', you will see the following > NPE exception. Seems the type in hivePrivObject is not initialized. > {noformat} > FAILED: Execution Error, return code 1 from > org.apache.hadoop.hive.ql.exec.DDLTask. java.lang.NullPointerException > at > org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLAuthorizationUtils.isOwner(SQLAuthorizationUtils.java:265) > at > org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLAuthorizationUtils.getPrivilegesFromMetaStore(SQLAuthorizationUtils.java:212) > at > org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.GrantPrivAuthUtils.checkRequiredPrivileges(GrantPrivAuthUtils.java:64) > at > org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.GrantPrivAuthUtils.authorize(GrantPrivAuthUtils.java:50) > at > org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAccessController.grantPrivileges(SQLStdHiveAccessController.java:179) > at > org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAccessControllerWrapper.grantPrivileges(SQLStdHiveAccessControllerWrapper.java:70) > at > org.apache.hadoop.hive.ql.security.authorization.plugin.HiveAuthorizerImpl.grantPrivileges(HiveAuthorizerImpl.java:48) > at > org.apache.hadoop.hive.ql.exec.DDLTask.grantOrRevokePrivileges(DDLTask.java:1123 > {noformat} -- This message was sent by Atlassian JIRA (v7.6.3#76005)