You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ranger.apache.org by Verhaeghe Philippe <Ph...@worldline.com> on 2015/03/02 17:05:40 UTC
Group permissions in Hive policies
Hi,
I try to use group level permissions for Hive but it seems not working.
I have set permissions at user level for my user "tableau2" : it works as expected, I can query Hive.
I have created another user "tableau3", placed it in a new group "tableau", and I gave this group the same permissions than the user "tableau2" : I cannot query Hive with user "tableau3".
Does anyone has successfully used group level permissions with Hive ?
Regards,
Philippe
________________________________
Ce message et les pi?ces jointes sont confidentiels et r?serv?s ? l'usage exclusif de ses destinataires. Il peut ?galement ?tre prot?g? par le secret professionnel. Si vous recevez ce message par erreur, merci d'en avertir imm?diatement l'exp?diteur et de le d?truire. L'int?grit? du message ne pouvant ?tre assur?e sur Internet, la responsabilit? de Worldline ne pourra ?tre recherch?e quant au contenu de ce message. Bien que les meilleurs efforts soient faits pour maintenir cette transmission exempte de tout virus, l'exp?diteur ne donne aucune garantie ? cet ?gard et sa responsabilit? ne saurait ?tre recherch?e pour tout dommage r?sultant d'un virus transmis.
This e-mail and the documents attached are confidential and intended solely for the addressee; it may also be privileged. If you receive this e-mail in error, please notify the sender immediately and destroy it. As its integrity cannot be secured on the Internet, the Worldline liability cannot be triggered for the message content. Although the sender endeavours to maintain a computer virus-free network, the sender does not warrant that this transmission is virus-free and will not be liable for any damages resulting from any virus transmitted.
Re: Group permissions in Hive policies
Posted by Gautam Borad <gb...@gmail.com>.
Hi Philippe,
In order for the enforcement of policies to happen, the group should be
present in Hadoop.
Ranger groups are more of a UI help currently in that they provide
autocomplete to users while creating policies. This way user need not
lookup Hadoop Groups every time and can rely on autocomplete to create
policies.
Ranger Usersync is generally used to sync users/groups to Ranger Admin to
avoid the tedious process of creating them on the Ranger Admin.
On Mon, Mar 2, 2015 at 10:20 PM, Verhaeghe Philippe <
Philippe.Verhaeghe@worldline.com> wrote:
> Thanks for your answer.
>
> The users tableau2 and tableau3 and the group tableau are internal in
> ranger.
>
> There is no “tableau” group in Hadoop, I created the group only in ranger.
>
> $ hdfs groups tableau3
>
> tableau3 :
>
> $ hdfs groups tableau2
>
> tableau2 :
>
>
>
> I don’t fully understand why the group associated with the login should be
> created in Hadoop when ranger is managing the permissions. And what is the
> role of the Ranger group vs Hadoop group ?
>
>
>
> Regards,
>
> Philippe
>
>
>
> *De :* Selvamohan Neethiraj [mailto:sneethiraj@hortonworks.com] *De la
> part de* Selvamohan Neethiraj
> *Envoyé :* Monday, March 02, 2015 5:32 PM
> *À :* user@ranger.incubator.apache.org
> *Objet :* Re: Group permissions in Hive policies
>
>
>
> Philippe:
>
>
>
> Yes, we have validated permission defined at group level.
>
> When the Hive query is executed by HiveServer2, the groups associated with
> the login user is derived based on the Hadoop Group Mapping defined in the
> coe-site.xml (hadoop.security.group.mapping).
>
> You can use the following commands to find out the group membership for a
> given user:
>
>
>
> $ hdfs groups <username>
>
>
>
> Please let us know if your group membership for the user ‘tableau3’ user
> shows the group ‘tableau’.
>
>
>
> Thanks,
>
> Selva-
>
>
>
> *From: *Verhaeghe Philippe <Ph...@worldline.com>
> *Reply-To: *"user@ranger.incubator.apache.org" <
> user@ranger.incubator.apache.org>
> *Date: *Monday, March 2, 2015 at 11:05 AM
> *To: *"user@ranger.incubator.apache.org" <user@ranger.incubator.apache.org
> >
> *Subject: *Group permissions in Hive policies
>
>
>
> Hi,
>
>
>
> I try to use group level permissions for Hive but it seems not working.
>
> I have set permissions at user level for my user “tableau2” : it works as
> expected, I can query Hive.
>
> I have created another user “tableau3”, placed it in a new group
> “tableau”, and I gave this group the same permissions than the user
> “tableau2” : I cannot query Hive with user “tableau3”.
>
>
>
> Does anyone has successfully used group level permissions with Hive ?
>
>
>
> Regards,
>
> Philippe
>
>
>
>
> ------------------------------
>
>
> Ce message et les pièces jointes sont confidentiels et réservés à l'usage
> exclusif de ses destinataires. Il peut également être protégé par le secret
> professionnel. Si vous recevez ce message par erreur, merci d'en avertir
> immédiatement l'expéditeur et de le détruire. L'intégrité du message ne
> pouvant être assurée sur Internet, la responsabilité de Worldline ne pourra
> être recherchée quant au contenu de ce message. Bien que les meilleurs
> efforts soient faits pour maintenir cette transmission exempte de tout
> virus, l'expéditeur ne donne aucune garantie à cet égard et sa
> responsabilité ne saurait être recherchée pour tout dommage résultant d'un
> virus transmis.
>
> This e-mail and the documents attached are confidential and intended
> solely for the addressee; it may also be privileged. If you receive this
> e-mail in error, please notify the sender immediately and destroy it. As
> its integrity cannot be secured on the Internet, the Worldline liability
> cannot be triggered for the message content. Although the sender endeavours
> to maintain a computer virus-free network, the sender does not warrant that
> this transmission is virus-free and will not be liable for any damages
> resulting from any virus transmitted.
>
> ------------------------------
>
> Ce message et les pièces jointes sont confidentiels et réservés à l'usage
> exclusif de ses destinataires. Il peut également être protégé par le secret
> professionnel. Si vous recevez ce message par erreur, merci d'en avertir
> immédiatement l'expéditeur et de le détruire. L'intégrité du message ne
> pouvant être assurée sur Internet, la responsabilité de Worldline ne pourra
> être recherchée quant au contenu de ce message. Bien que les meilleurs
> efforts soient faits pour maintenir cette transmission exempte de tout
> virus, l'expéditeur ne donne aucune garantie à cet égard et sa
> responsabilité ne saurait être recherchée pour tout dommage résultant d'un
> virus transmis.
>
> This e-mail and the documents attached are confidential and intended
> solely for the addressee; it may also be privileged. If you receive this
> e-mail in error, please notify the sender immediately and destroy it. As
> its integrity cannot be secured on the Internet, the Worldline liability
> cannot be triggered for the message content. Although the sender endeavours
> to maintain a computer virus-free network, the sender does not warrant that
> this transmission is virus-free and will not be liable for any damages
> resulting from any virus transmitted.
>
--
Regards,
Gautam.
RE: Group permissions in Hive policies
Posted by Verhaeghe Philippe <Ph...@worldline.com>.
Thanks for your answer.
The users tableau2 and tableau3 and the group tableau are internal in ranger.
There is no "tableau" group in Hadoop, I created the group only in ranger.
$ hdfs groups tableau3
tableau3 :
$ hdfs groups tableau2
tableau2 :
I don't fully understand why the group associated with the login should be created in Hadoop when ranger is managing the permissions. And what is the role of the Ranger group vs Hadoop group ?
Regards,
Philippe
De : Selvamohan Neethiraj [mailto:sneethiraj@hortonworks.com] De la part de Selvamohan Neethiraj
Envoyé : Monday, March 02, 2015 5:32 PM
À : user@ranger.incubator.apache.org
Objet : Re: Group permissions in Hive policies
Philippe:
Yes, we have validated permission defined at group level.
When the Hive query is executed by HiveServer2, the groups associated with the login user is derived based on the Hadoop Group Mapping defined in the coe-site.xml (hadoop.security.group.mapping).
You can use the following commands to find out the group membership for a given user:
$ hdfs groups <username>
Please let us know if your group membership for the user 'tableau3' user shows the group 'tableau'.
Thanks,
Selva-
From: Verhaeghe Philippe <Ph...@worldline.com>>
Reply-To: "user@ranger.incubator.apache.org<ma...@ranger.incubator.apache.org>" <us...@ranger.incubator.apache.org>>
Date: Monday, March 2, 2015 at 11:05 AM
To: "user@ranger.incubator.apache.org<ma...@ranger.incubator.apache.org>" <us...@ranger.incubator.apache.org>>
Subject: Group permissions in Hive policies
[cid:image001.jpg@01D05510.5765A020]
Hi,
I try to use group level permissions for Hive but it seems not working.
I have set permissions at user level for my user "tableau2" : it works as expected, I can query Hive.
I have created another user "tableau3", placed it in a new group "tableau", and I gave this group the same permissions than the user "tableau2" : I cannot query Hive with user "tableau3".
Does anyone has successfully used group level permissions with Hive ?
Regards,
Philippe
________________________________
Ce message et les pièces jointes sont confidentiels et réservés à l'usage exclusif de ses destinataires. Il peut également être protégé par le secret professionnel. Si vous recevez ce message par erreur, merci d'en avertir immédiatement l'expéditeur et de le détruire. L'intégrité du message ne pouvant être assurée sur Internet, la responsabilité de Worldline ne pourra être recherchée quant au contenu de ce message. Bien que les meilleurs efforts soient faits pour maintenir cette transmission exempte de tout virus, l'expéditeur ne donne aucune garantie à cet égard et sa responsabilité ne saurait être recherchée pour tout dommage résultant d'un virus transmis.
This e-mail and the documents attached are confidential and intended solely for the addressee; it may also be privileged. If you receive this e-mail in error, please notify the sender immediately and destroy it. As its integrity cannot be secured on the Internet, the Worldline liability cannot be triggered for the message content. Although the sender endeavours to maintain a computer virus-free network, the sender does not warrant that this transmission is virus-free and will not be liable for any damages resulting from any virus transmitted.
________________________________
Ce message et les pièces jointes sont confidentiels et réservés à l'usage exclusif de ses destinataires. Il peut également être protégé par le secret professionnel. Si vous recevez ce message par erreur, merci d'en avertir immédiatement l'expéditeur et de le détruire. L'intégrité du message ne pouvant être assurée sur Internet, la responsabilité de Worldline ne pourra être recherchée quant au contenu de ce message. Bien que les meilleurs efforts soient faits pour maintenir cette transmission exempte de tout virus, l'expéditeur ne donne aucune garantie à cet égard et sa responsabilité ne saurait être recherchée pour tout dommage résultant d'un virus transmis.
This e-mail and the documents attached are confidential and intended solely for the addressee; it may also be privileged. If you receive this e-mail in error, please notify the sender immediately and destroy it. As its integrity cannot be secured on the Internet, the Worldline liability cannot be triggered for the message content. Although the sender endeavours to maintain a computer virus-free network, the sender does not warrant that this transmission is virus-free and will not be liable for any damages resulting from any virus transmitted.
Re: Group permissions in Hive policies
Posted by Selvamohan Neethiraj <sn...@apache.org>.
Philippe:
Yes, we have validated permission defined at group level.
When the Hive query is executed by HiveServer2, the groups associated with
the login user is derived based on the Hadoop Group Mapping defined in the
coe-site.xml (hadoop.security.group.mapping).
You can use the following commands to find out the group membership for a
given user:
$ hdfs groups <username>
Please let us know if your group membership for the user tableau3¹ user
shows the group tableau¹.
Thanks,
Selva-
From: Verhaeghe Philippe <Ph...@worldline.com>
Reply-To: "user@ranger.incubator.apache.org"
<us...@ranger.incubator.apache.org>
Date: Monday, March 2, 2015 at 11:05 AM
To: "user@ranger.incubator.apache.org" <us...@ranger.incubator.apache.org>
Subject: Group permissions in Hive policies
Hi,
I try to use group level permissions for Hive but it seems not working.
I have set permissions at user level for my user ³tableau2² : it works as
expected, I can query Hive.
I have created another user ³tableau3², placed it in a new group ³tableau²,
and I gave this group the same permissions than the user ³tableau2² : I
cannot query Hive with user ³tableau3².
Does anyone has successfully used group level permissions with Hive ?
Regards,
Philippe
Ce message et les pièces jointes sont confidentiels et réservés à l'usage
exclusif de ses destinataires. Il peut également être protégé par le secret
professionnel. Si vous recevez ce message par erreur, merci d'en avertir
immédiatement l'expéditeur et de le détruire. L'intégrité du message ne
pouvant être assurée sur Internet, la responsabilité de Worldline ne pourra
être recherchée quant au contenu de ce message. Bien que les meilleurs
efforts soient faits pour maintenir cette transmission exempte de tout
virus, l'expéditeur ne donne aucune garantie à cet égard et sa
responsabilité ne saurait être recherchée pour tout dommage résultant d'un
virus transmis.
This e-mail and the documents attached are confidential and intended solely
for the addressee; it may also be privileged. If you receive this e-mail in
error, please notify the sender immediately and destroy it. As its integrity
cannot be secured on the Internet, the Worldline liability cannot be
triggered for the message content. Although the sender endeavours to
maintain a computer virus-free network, the sender does not warrant that
this transmission is virus-free and will not be liable for any damages
resulting from any virus transmitted.