Reply
Explorer
Posts: 32
Registered: ‎11-03-2015

Help with Role Assignments / New Install

Hello, 

On Hive with Sentry, how can I see which users or groups are assigned to a role ?

I am able to see what DB a role impacts, but not what users/groups that role is assigned.

 

Bye

Omar

Cloudera Employee
Posts: 26
Registered: ‎10-25-2014

Re: Help with Role Assignments / New Install

SHOW statement should help:

 

http://www.cloudera.com/content/www/en-us/documentation/enterprise/latest/topics/sg_hive_sql.html#co...

 

Also -- see http://www.cloudera.com/content/www/en-us/documentation/enterprise/latest/topics/cm_sg_sentry_servic...

 

-- for general information about Sentry Service and how roles, users, and groups are mapped therein.

Highlighted
Explorer
Posts: 32
Registered: ‎11-03-2015

Re: Help with Role Assignments / New Install

Hi, thanks for your reply but my question was precise.

 

For istance:

show role grant group <groupname>  shows me roles assigned to the group

show grant role <rolename> shows me objects managed by the role

 

I can't find a way to see roles assigned to a group, something like

show roles on group <groupname>

This way it would be much simplier, given a group, to know what that group is able to see.

 

Hope this is more clear now.

Bye

Omar

Announcements