Solved

Where are Permission Set descriptions stored?

Userlevel 6

+18

I’m trying to query for permission set names and descriptions but I cannot find where the descriptions are stored. Can anyone point me to it?

Debug isn’t any use. I have the names and what is granted to users but I cannot find where the descriptions are stored to output those…

Thanks!

Nick

icon

Best answer by NickPorter 12 December 2022, 15:52

Userlevel 6

+18

Never mind, I found it. FND_ROLE.

For some reason it was initially returning no rows, but now it is working fine. Must be a Monday.

Userlevel 7

+22

Hi @NickPorter

try this:

Select * from ifsapp.FND_ROLE_TAB

Sign up