question Re: how to know which group is linked to a sentry role by command line in Support Questions

how to know which group is linked to a sentry role by command line

yagoaparecidoti — Mon, 29 Aug 2022 20:46:41 GMT

hello cloudera community,

how can we find out which group is tied to a sentry role by command line?

Re: how to know which group is linked to a sentry role by command line

araujo — Mon, 29 Aug 2022 23:04:20 GMT

@yagoaparecidoti ,

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:

select r.ROLE_NAME, g.GROUP_NAME from SENTRY_GROUP g join SENTRY_ROLE_GROUP_MAP rg on rg.GROUP_ID = g.GROUP_ID join SENTRY_ROLE r on r.ROLE_ID = rg.ROLE_ID order by r.ROLE_NAME, g.GROUP_NAME ;

Cheers,

André

Re: how to know which group is linked to a sentry role by command line

yagoaparecidoti — Tue, 30 Aug 2022 12:32:44 GMT

hi @araujo

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.

Re: how to know which group is linked to a sentry role by command line

araujo — Tue, 30 Aug 2022 22:41:13 GMT

@yagoaparecidoti ,

The opposite command doesn't exist, as far as I know. Querying the database is the only option that I'm aware.

Cheers,

André