Skip to main content

There must be a smarter way then browsing the permission set details and clicking all branches in the tree ...

if a database query works for you, try select * from PRES_OBJECT_GRANT_TAB t


Thanks! That query works (on the view as I don't have access to the table), but I now realize I should have asked a more specific question: how can I get an overview of all presentation objects per functional role?


will this query work? 

 

select * from PRES_OBJECT_GRANT_TAB t
where role in (select role from FND_ROLE_TAB t
where fnd_role_type = 'BUILDROLE')


sorry, forgot that you don’t have table access, try with views as per below.

 

select * from PRES_OBJECT_GRANT t
where role in (select role from FND_ROLE t
where fnd_role_type_db = 'BUILDROLE')


Maybe the Security Per User report could be useful for your requirement. You need to find a User who granted your permission set (Right click on Permission set details → Show Users granted This) and then order the Security Per User report with User ID and your permission set.

 

Cheers!

Damith


Reply