01-15-2016 03:27 AM
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.
01-20-2016 01:01 PM
SHOW statement should help:
-- for general information about Sentry Service and how roles, users, and groups are mapped therein.
01-22-2016 06:18 AM
Hi, thanks for your reply but my question was precise.
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.