Skip to main content

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

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.


Hi @NickPorter 

try this:

Select * from ifsapp.FND_ROLE_TAB


Reply