There must be a smarter way then browsing the permission set details and clicking all branches in the tree ...
Best answer by Rusiru Dharmadasa
View originalThere must be a smarter way then browsing the permission set details and clicking all branches in the tree ...
Best answer by Rusiru Dharmadasa
View originalMaybe 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
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')
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')
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?
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.