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 2010/11/04 07:29:46 UTC

[jira] Updated: (HIVE-78) Authorization infrastructure for Hive

     [ https://issues.apache.org/jira/browse/HIVE-78?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

He Yongqiang updated HIVE-78:
-----------------------------

    Attachment: HIVE-78.1.nothrift.patch
                HIVE-78.1.thrift.patch

Attach two patches. One is including thrift generated code in case anyone wants to try it. 
The other is just java code changes for a clean review.

These two patches only contains DDL and metadata changes. There are no integration code with query execution part. will do that in the following patch.

Some examples:

    > show grant user `test` on table `src`;                 
OK
Time taken: 0.081 seconds

hive> grant `select` on table src to user test, group grp;   
OK
Time taken: 0.118 seconds

hive> show grant user `test` on table `src`;              
OK
dbName:default
tableName:src
userName:test
isRole:false
isGroup:false
privileges:Select
grantTime:1288850969
grantor:
grantor:
Time taken: 0.09 seconds

hive> show grant group `grp` on table `src`;                 
OK
dbName:default
tableName:src
userName:grp
isRole:false
isGroup:true
privileges:Select
grantTime:1288850969
grantor:
grantor:
Time taken: 0.08 seconds

hive> revoke `select` on table src from user test;           
OK
Time taken: 0.041 seconds

hive> show grant user `test` on table `src`;      
OK
Time taken: 0.078 seconds

hive> show grant group `grp` on table `src`;      
OK
dbName:default
tableName:src
userName:grp
isRole:false
isGroup:true
privileges:Select
grantTime:1288850969
grantor:
grantor:
Time taken: 0.079 seconds

>grant `select`(key, value) on table src to user test;
OK
Time taken: 0.174 seconds

> show grant user `test` on table `src`(key);       
OK
dbName:default
tableName:src
columnName:key
userName:test
isRole:false
isGroup:false
privileges:Select
grantTime:1288851160
grantor:
grantor:
Time taken: 6.722 seconds

hive> show grant user `test` on table `src`(key, value);
OK
dbName:default
tableName:src
columnName:key
userName:test
isRole:false
isGroup:false
privileges:Select
grantTime:1288851160
grantor:
dbName:default
tableName:src
columnName:value
userName:test
isRole:false
isGroup:false
privileges:Select
grantTime:1288851160
grantor:
grantor:


> Authorization infrastructure for Hive
> -------------------------------------
>
>                 Key: HIVE-78
>                 URL: https://issues.apache.org/jira/browse/HIVE-78
>             Project: Hive
>          Issue Type: New Feature
>          Components: Metastore, Query Processor, Server Infrastructure
>            Reporter: Ashish Thusoo
>            Assignee: He Yongqiang
>         Attachments: createuser-v1.patch, hive-78-metadata-v1.patch, hive-78-syntax-v1.patch, HIVE-78.1.nothrift.patch, HIVE-78.1.thrift.patch, hive-78.diff
>
>
> Allow hive to integrate with existing user repositories for authentication and authorization infromation.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.