Solved

Where are Permission Set descriptions stored?

+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

Best answer by NickPorter

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.

+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.

+23

Hi @NickPorter

try this:

Select * from ifsapp.FND_ROLE_TAB

Kind regards

Sign up