Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Help with Role Assignments / New Install

Help with Role Assignments / New Install

Contributor

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

2 REPLIES 2
Highlighted

Re: Help with Role Assignments / New Install

Cloudera Employee

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

Re: Help with Role Assignments / New Install

Contributor

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

Don't have an account?
Coming from Hortonworks? Activate your account here