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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.