You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "He Yongqiang (JIRA)" <ji...@apache.org> on 2011/08/24 21:36:29 UTC
[jira] [Created] (HIVE-2405) get_privilege does not get user level
privilege
get_privilege does not get user level privilege
-----------------------------------------------
Key: HIVE-2405
URL: https://issues.apache.org/jira/browse/HIVE-2405
Project: Hive
Issue Type: Bug
Reporter: He Yongqiang
Assignee: He Yongqiang
hive> set hive.security.authorization.enabled=true;
hive> grant all to user heyongqiang;
hive> show grant user heyongqiang;
principalName heyongqiang
principalType USER
privilege All
grantTime Wed Aug 24 11:51:54 PDT 2011
grantor heyongqiang
Time taken: 0.032 seconds
hive> CREATE TABLE src (foo INT, bar STRING);
Authorization failed:No privilege 'Create' found for outputs { database:default}. Use show grant to get more details.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-2405) get_privilege does not get user
level privilege
Posted by "jiraposter@reviews.apache.org (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2405?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13090444#comment-13090444 ]
jiraposter@reviews.apache.org commented on HIVE-2405:
-----------------------------------------------------
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/1644/
-----------------------------------------------------------
Review request for hive.
Summary
-------
get_privilege does not get user level privilege
This addresses bug HIVE-2405.
https://issues.apache.org/jira/browse/HIVE-2405
Diffs
-----
trunk/metastore/src/java/org/apache/hadoop/hive/metastore/HiveMetaStore.java 1161232
trunk/ql/src/test/queries/clientpositive/authorization_7.q PRE-CREATION
trunk/ql/src/test/results/clientpositive/authorization_7.q.out PRE-CREATION
Diff: https://reviews.apache.org/r/1644/diff
Testing
-------
added a new testcase
Thanks,
Yongqiang
> get_privilege does not get user level privilege
> -----------------------------------------------
>
> Key: HIVE-2405
> URL: https://issues.apache.org/jira/browse/HIVE-2405
> Project: Hive
> Issue Type: Bug
> Reporter: He Yongqiang
> Assignee: He Yongqiang
> Attachments: HIVE-2405.1.patch
>
>
> hive> set hive.security.authorization.enabled=true;
> hive> grant all to user heyongqiang;
> hive> show grant user heyongqiang;
> principalName heyongqiang
> principalType USER
> privilege All
> grantTime Wed Aug 24 11:51:54 PDT 2011
> grantor heyongqiang
> Time taken: 0.032 seconds
> hive> CREATE TABLE src (foo INT, bar STRING);
> Authorization failed:No privilege 'Create' found for outputs { database:default}. Use show grant to get more details.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-2405) get_privilege does not get user level
privilege
Posted by "He Yongqiang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2405?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
He Yongqiang updated HIVE-2405:
-------------------------------
Attachment: HIVE-2405.1.patch
> get_privilege does not get user level privilege
> -----------------------------------------------
>
> Key: HIVE-2405
> URL: https://issues.apache.org/jira/browse/HIVE-2405
> Project: Hive
> Issue Type: Bug
> Reporter: He Yongqiang
> Assignee: He Yongqiang
> Attachments: HIVE-2405.1.patch
>
>
> hive> set hive.security.authorization.enabled=true;
> hive> grant all to user heyongqiang;
> hive> show grant user heyongqiang;
> principalName heyongqiang
> principalType USER
> privilege All
> grantTime Wed Aug 24 11:51:54 PDT 2011
> grantor heyongqiang
> Time taken: 0.032 seconds
> hive> CREATE TABLE src (foo INT, bar STRING);
> Authorization failed:No privilege 'Create' found for outputs { database:default}. Use show grant to get more details.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-2405) get_privilege does not get user
level privilege
Posted by "John Sichi (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2405?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13103861#comment-13103861 ]
John Sichi commented on HIVE-2405:
----------------------------------
+1. Will commit when tests pass.
> get_privilege does not get user level privilege
> -----------------------------------------------
>
> Key: HIVE-2405
> URL: https://issues.apache.org/jira/browse/HIVE-2405
> Project: Hive
> Issue Type: Bug
> Reporter: He Yongqiang
> Assignee: He Yongqiang
> Attachments: HIVE-2405.1.patch, HIVE-2405.2.patch
>
>
> hive> set hive.security.authorization.enabled=true;
> hive> grant all to user heyongqiang;
> hive> show grant user heyongqiang;
> principalName heyongqiang
> principalType USER
> privilege All
> grantTime Wed Aug 24 11:51:54 PDT 2011
> grantor heyongqiang
> Time taken: 0.032 seconds
> hive> CREATE TABLE src (foo INT, bar STRING);
> Authorization failed:No privilege 'Create' found for outputs { database:default}. Use show grant to get more details.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-2405) get_privilege does not get user
level privilege
Posted by "Hudson (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2405?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13104344#comment-13104344 ]
Hudson commented on HIVE-2405:
------------------------------
Integrated in Hive-trunk-h0.21 #952 (See [https://builds.apache.org/job/Hive-trunk-h0.21/952/])
HIVE-2405. get_privilege does not get user level privilege
(He Yongqiang via jvs)
jvs : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1170398
Files :
* /hive/trunk/metastore/src/java/org/apache/hadoop/hive/metastore/HiveMetaStore.java
* /hive/trunk/ql/src/test/queries/clientpositive/authorization_7.q
* /hive/trunk/ql/src/test/results/clientpositive/authorization_7.q.out
> get_privilege does not get user level privilege
> -----------------------------------------------
>
> Key: HIVE-2405
> URL: https://issues.apache.org/jira/browse/HIVE-2405
> Project: Hive
> Issue Type: Bug
> Reporter: He Yongqiang
> Assignee: He Yongqiang
> Fix For: 0.9.0
>
> Attachments: HIVE-2405.1.patch, HIVE-2405.2.patch
>
>
> hive> set hive.security.authorization.enabled=true;
> hive> grant all to user heyongqiang;
> hive> show grant user heyongqiang;
> principalName heyongqiang
> principalType USER
> privilege All
> grantTime Wed Aug 24 11:51:54 PDT 2011
> grantor heyongqiang
> Time taken: 0.032 seconds
> hive> CREATE TABLE src (foo INT, bar STRING);
> Authorization failed:No privilege 'Create' found for outputs { database:default}. Use show grant to get more details.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-2405) get_privilege does not get user level
privilege
Posted by "John Sichi (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2405?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
John Sichi updated HIVE-2405:
-----------------------------
Resolution: Fixed
Fix Version/s: 0.9.0
Hadoop Flags: [Reviewed]
Status: Resolved (was: Patch Available)
Committed to trunk. Thanks Yongqiang!
> get_privilege does not get user level privilege
> -----------------------------------------------
>
> Key: HIVE-2405
> URL: https://issues.apache.org/jira/browse/HIVE-2405
> Project: Hive
> Issue Type: Bug
> Reporter: He Yongqiang
> Assignee: He Yongqiang
> Fix For: 0.9.0
>
> Attachments: HIVE-2405.1.patch, HIVE-2405.2.patch
>
>
> hive> set hive.security.authorization.enabled=true;
> hive> grant all to user heyongqiang;
> hive> show grant user heyongqiang;
> principalName heyongqiang
> principalType USER
> privilege All
> grantTime Wed Aug 24 11:51:54 PDT 2011
> grantor heyongqiang
> Time taken: 0.032 seconds
> hive> CREATE TABLE src (foo INT, bar STRING);
> Authorization failed:No privilege 'Create' found for outputs { database:default}. Use show grant to get more details.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-2405) get_privilege does not get user
level privilege
Posted by "jiraposter@reviews.apache.org (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2405?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13090798#comment-13090798 ]
jiraposter@reviews.apache.org commented on HIVE-2405:
-----------------------------------------------------
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/1646/#review1632
-----------------------------------------------------------
Just a minor clarification. Otherwise looks good to me.
trunk/ql/src/test/queries/clientpositive/authorization_7.q
<https://reviews.apache.org/r/1646/#comment3671>
is it necessary to set this after GRANT ALL ...?
- Ning
On 2011-08-24 22:23:39, Yongqiang He wrote:
bq.
bq. -----------------------------------------------------------
bq. This is an automatically generated e-mail. To reply, visit:
bq. https://reviews.apache.org/r/1646/
bq. -----------------------------------------------------------
bq.
bq. (Updated 2011-08-24 22:23:39)
bq.
bq.
bq. Review request for hive and Ning Zhang.
bq.
bq.
bq. Summary
bq. -------
bq.
bq. get_privilege does not get user level privilege and should return emptylist instead of null
bq.
bq.
bq. This addresses bug HIVE-2405.
bq. https://issues.apache.org/jira/browse/HIVE-2405
bq.
bq.
bq. Diffs
bq. -----
bq.
bq. trunk/metastore/src/java/org/apache/hadoop/hive/metastore/HiveMetaStore.java 1161232
bq. trunk/ql/src/test/queries/clientpositive/authorization_7.q PRE-CREATION
bq. trunk/ql/src/test/results/clientpositive/authorization_7.q.out PRE-CREATION
bq.
bq. Diff: https://reviews.apache.org/r/1646/diff
bq.
bq.
bq. Testing
bq. -------
bq.
bq.
bq. Thanks,
bq.
bq. Yongqiang
bq.
bq.
> get_privilege does not get user level privilege
> -----------------------------------------------
>
> Key: HIVE-2405
> URL: https://issues.apache.org/jira/browse/HIVE-2405
> Project: Hive
> Issue Type: Bug
> Reporter: He Yongqiang
> Assignee: He Yongqiang
> Attachments: HIVE-2405.1.patch, HIVE-2405.2.patch
>
>
> hive> set hive.security.authorization.enabled=true;
> hive> grant all to user heyongqiang;
> hive> show grant user heyongqiang;
> principalName heyongqiang
> principalType USER
> privilege All
> grantTime Wed Aug 24 11:51:54 PDT 2011
> grantor heyongqiang
> Time taken: 0.032 seconds
> hive> CREATE TABLE src (foo INT, bar STRING);
> Authorization failed:No privilege 'Create' found for outputs { database:default}. Use show grant to get more details.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-2405) get_privilege does not get user
level privilege
Posted by "He Yongqiang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2405?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13090560#comment-13090560 ]
He Yongqiang commented on HIVE-2405:
------------------------------------
a new patch merged with HIVE-2406
> get_privilege does not get user level privilege
> -----------------------------------------------
>
> Key: HIVE-2405
> URL: https://issues.apache.org/jira/browse/HIVE-2405
> Project: Hive
> Issue Type: Bug
> Reporter: He Yongqiang
> Assignee: He Yongqiang
> Attachments: HIVE-2405.1.patch, HIVE-2405.2.patch
>
>
> hive> set hive.security.authorization.enabled=true;
> hive> grant all to user heyongqiang;
> hive> show grant user heyongqiang;
> principalName heyongqiang
> principalType USER
> privilege All
> grantTime Wed Aug 24 11:51:54 PDT 2011
> grantor heyongqiang
> Time taken: 0.032 seconds
> hive> CREATE TABLE src (foo INT, bar STRING);
> Authorization failed:No privilege 'Create' found for outputs { database:default}. Use show grant to get more details.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-2405) get_privilege does not get user
level privilege
Posted by "jiraposter@reviews.apache.org (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2405?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13098409#comment-13098409 ]
jiraposter@reviews.apache.org commented on HIVE-2405:
-----------------------------------------------------
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/1646/#review1774
-----------------------------------------------------------
trunk/ql/src/test/queries/clientpositive/authorization_7.q
<https://reviews.apache.org/r/1646/#comment4051>
yes. what we want to do is to test the global privilege. The first command is to grant a global privilege, and after that do test with that.
- Yongqiang
On 2011-08-24 22:23:39, Yongqiang He wrote:
bq.
bq. -----------------------------------------------------------
bq. This is an automatically generated e-mail. To reply, visit:
bq. https://reviews.apache.org/r/1646/
bq. -----------------------------------------------------------
bq.
bq. (Updated 2011-08-24 22:23:39)
bq.
bq.
bq. Review request for hive and Ning Zhang.
bq.
bq.
bq. Summary
bq. -------
bq.
bq. get_privilege does not get user level privilege and should return emptylist instead of null
bq.
bq.
bq. This addresses bug HIVE-2405.
bq. https://issues.apache.org/jira/browse/HIVE-2405
bq.
bq.
bq. Diffs
bq. -----
bq.
bq. trunk/metastore/src/java/org/apache/hadoop/hive/metastore/HiveMetaStore.java 1161232
bq. trunk/ql/src/test/queries/clientpositive/authorization_7.q PRE-CREATION
bq. trunk/ql/src/test/results/clientpositive/authorization_7.q.out PRE-CREATION
bq.
bq. Diff: https://reviews.apache.org/r/1646/diff
bq.
bq.
bq. Testing
bq. -------
bq.
bq.
bq. Thanks,
bq.
bq. Yongqiang
bq.
bq.
> get_privilege does not get user level privilege
> -----------------------------------------------
>
> Key: HIVE-2405
> URL: https://issues.apache.org/jira/browse/HIVE-2405
> Project: Hive
> Issue Type: Bug
> Reporter: He Yongqiang
> Assignee: He Yongqiang
> Attachments: HIVE-2405.1.patch, HIVE-2405.2.patch
>
>
> hive> set hive.security.authorization.enabled=true;
> hive> grant all to user heyongqiang;
> hive> show grant user heyongqiang;
> principalName heyongqiang
> principalType USER
> privilege All
> grantTime Wed Aug 24 11:51:54 PDT 2011
> grantor heyongqiang
> Time taken: 0.032 seconds
> hive> CREATE TABLE src (foo INT, bar STRING);
> Authorization failed:No privilege 'Create' found for outputs { database:default}. Use show grant to get more details.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-2405) get_privilege does not get user level
privilege
Posted by "Carl Steinbach (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2405?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Carl Steinbach updated HIVE-2405:
---------------------------------
Component/s: Security
Authorization
> get_privilege does not get user level privilege
> -----------------------------------------------
>
> Key: HIVE-2405
> URL: https://issues.apache.org/jira/browse/HIVE-2405
> Project: Hive
> Issue Type: Bug
> Components: Authorization, Security
> Reporter: He Yongqiang
> Assignee: He Yongqiang
> Fix For: 0.8.0
>
> Attachments: HIVE-2405.1.patch, HIVE-2405.2.patch
>
>
> hive> set hive.security.authorization.enabled=true;
> hive> grant all to user heyongqiang;
> hive> show grant user heyongqiang;
> principalName heyongqiang
> principalType USER
> privilege All
> grantTime Wed Aug 24 11:51:54 PDT 2011
> grantor heyongqiang
> Time taken: 0.032 seconds
> hive> CREATE TABLE src (foo INT, bar STRING);
> Authorization failed:No privilege 'Create' found for outputs { database:default}. Use show grant to get more details.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-2405) get_privilege does not get user
level privilege
Posted by "jiraposter@reviews.apache.org (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2405?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13090563#comment-13090563 ]
jiraposter@reviews.apache.org commented on HIVE-2405:
-----------------------------------------------------
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/1646/
-----------------------------------------------------------
Review request for hive and Ning Zhang.
Summary
-------
get_privilege does not get user level privilege and should return emptylist instead of null
This addresses bug HIVE-2405.
https://issues.apache.org/jira/browse/HIVE-2405
Diffs
-----
trunk/metastore/src/java/org/apache/hadoop/hive/metastore/HiveMetaStore.java 1161232
trunk/ql/src/test/queries/clientpositive/authorization_7.q PRE-CREATION
trunk/ql/src/test/results/clientpositive/authorization_7.q.out PRE-CREATION
Diff: https://reviews.apache.org/r/1646/diff
Testing
-------
Thanks,
Yongqiang
> get_privilege does not get user level privilege
> -----------------------------------------------
>
> Key: HIVE-2405
> URL: https://issues.apache.org/jira/browse/HIVE-2405
> Project: Hive
> Issue Type: Bug
> Reporter: He Yongqiang
> Assignee: He Yongqiang
> Attachments: HIVE-2405.1.patch, HIVE-2405.2.patch
>
>
> hive> set hive.security.authorization.enabled=true;
> hive> grant all to user heyongqiang;
> hive> show grant user heyongqiang;
> principalName heyongqiang
> principalType USER
> privilege All
> grantTime Wed Aug 24 11:51:54 PDT 2011
> grantor heyongqiang
> Time taken: 0.032 seconds
> hive> CREATE TABLE src (foo INT, bar STRING);
> Authorization failed:No privilege 'Create' found for outputs { database:default}. Use show grant to get more details.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-2405) get_privilege does not get user level
privilege
Posted by "He Yongqiang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2405?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
He Yongqiang updated HIVE-2405:
-------------------------------
Status: Patch Available (was: Open)
> get_privilege does not get user level privilege
> -----------------------------------------------
>
> Key: HIVE-2405
> URL: https://issues.apache.org/jira/browse/HIVE-2405
> Project: Hive
> Issue Type: Bug
> Reporter: He Yongqiang
> Assignee: He Yongqiang
> Attachments: HIVE-2405.1.patch
>
>
> hive> set hive.security.authorization.enabled=true;
> hive> grant all to user heyongqiang;
> hive> show grant user heyongqiang;
> principalName heyongqiang
> principalType USER
> privilege All
> grantTime Wed Aug 24 11:51:54 PDT 2011
> grantor heyongqiang
> Time taken: 0.032 seconds
> hive> CREATE TABLE src (foo INT, bar STRING);
> Authorization failed:No privilege 'Create' found for outputs { database:default}. Use show grant to get more details.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-2405) get_privilege does not get user level
privilege
Posted by "He Yongqiang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2405?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
He Yongqiang updated HIVE-2405:
-------------------------------
Attachment: HIVE-2405.2.patch
> get_privilege does not get user level privilege
> -----------------------------------------------
>
> Key: HIVE-2405
> URL: https://issues.apache.org/jira/browse/HIVE-2405
> Project: Hive
> Issue Type: Bug
> Reporter: He Yongqiang
> Assignee: He Yongqiang
> Attachments: HIVE-2405.1.patch, HIVE-2405.2.patch
>
>
> hive> set hive.security.authorization.enabled=true;
> hive> grant all to user heyongqiang;
> hive> show grant user heyongqiang;
> principalName heyongqiang
> principalType USER
> privilege All
> grantTime Wed Aug 24 11:51:54 PDT 2011
> grantor heyongqiang
> Time taken: 0.032 seconds
> hive> CREATE TABLE src (foo INT, bar STRING);
> Authorization failed:No privilege 'Create' found for outputs { database:default}. Use show grant to get more details.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-2405) get_privilege does not get user
level privilege
Posted by "He Yongqiang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2405?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13090446#comment-13090446 ]
He Yongqiang commented on HIVE-2405:
------------------------------------
this patch can also be applied to 0.7
> get_privilege does not get user level privilege
> -----------------------------------------------
>
> Key: HIVE-2405
> URL: https://issues.apache.org/jira/browse/HIVE-2405
> Project: Hive
> Issue Type: Bug
> Reporter: He Yongqiang
> Assignee: He Yongqiang
> Attachments: HIVE-2405.1.patch
>
>
> hive> set hive.security.authorization.enabled=true;
> hive> grant all to user heyongqiang;
> hive> show grant user heyongqiang;
> principalName heyongqiang
> principalType USER
> privilege All
> grantTime Wed Aug 24 11:51:54 PDT 2011
> grantor heyongqiang
> Time taken: 0.032 seconds
> hive> CREATE TABLE src (foo INT, bar STRING);
> Authorization failed:No privilege 'Create' found for outputs { database:default}. Use show grant to get more details.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira