[ 
https://issues.apache.org/jira/browse/HIVE-78?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12756662#action_12756662
 ] 

Namit Jain commented on HIVE-78:
--------------------------------

I think, we should spend some time on finalizing the functionality before 
implementing it - it is very difficult to change something once it is out, due 
to all kinds of backward compatibility issues.

For the syntax, AS

wont it be simpler to add permissions to a role, and then assign roles to a 
user.



GRANT WITH_GRANT,RC, ON '*' TO 'USER1','USER2' AS my_permission

ALTER GRANT my_permission add USER 'USER3'


Can I revoke some privileges from my_permissions ?

If yes, how is it different from doing the two things differently ?


CREATE ROLE my_permission AS GRANT WITH_GRANT,RC, ON '*' ;
GRANT my_permission to USER1, USER2;

later

GRANT my_permission to USER3;

> Authentication infrastructure for Hive
> --------------------------------------
>
>                 Key: HIVE-78
>                 URL: https://issues.apache.org/jira/browse/HIVE-78
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Server Infrastructure
>            Reporter: Ashish Thusoo
>            Assignee: Edward Capriolo
>         Attachments: hive-78-metadata-v1.patch, hive-78-syntax-v1.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.

Reply via email to