[ 
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)

Reply via email to