hello cloudera community,
how can we find out which group is tied to a sentry role by command line?
The opposite command doesn't exist, as far as I know. Querying the database is the only option that I'm aware.
View solution in original post
You can do the reverse with the command "SHOW ROLE GRANT GROUP group name;".
I don't think there's a command to do exactly what you need, but you can query the database directly:
join SENTRY_ROLE_GROUP_MAP rg on rg.GROUP_ID = g.GROUP_ID
join SENTRY_ROLE r on r.ROLE_ID = rg.ROLE_ID
this command "SHOW ROLE GRANT GROUP group name" I know and already used, I thought there was a command that did the opposite.
well I will check in mysql then and soon return if it worked.