Skip to main content
araujo
araujoAnswer
Platinum ⭐️⭐️⭐️
Aug 30, 2022 10:41 PM UTC

@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é

 

-- Was your question answered? Please take some time to click on "Accept as Solution" below this post. If you find a reply useful, say thanks by clicking on the thumbs up button.

3 replies

araujo
Platinum ⭐️⭐️⭐️
Platinum ⭐️⭐️⭐️
Aug 29, 2022 11:04 PM UTC

@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é

Translate
-- Was your question answered? Please take some time to click on "Accept as Solution" below this post. If you find a reply useful, say thanks by clicking on the thumbs up button.
yagoaparecidoti
Gold ⭐️
Aug 30, 2022 12:32 PM UTC

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.

Translate
araujo
Platinum ⭐️⭐️⭐️
araujoAnswer
Platinum ⭐️⭐️⭐️
Aug 30, 2022 10:41 PM UTC

@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é

 

Translate
-- Was your question answered? Please take some time to click on "Accept as Solution" below this post. If you find a reply useful, say thanks by clicking on the thumbs up button.