Solved

How can I get an overview of all presentation objects per permission set?

  • 23 October 2019
  • 5 replies
  • 446 views

Userlevel 4
Badge +8

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

icon

Best answer by Rusiru Dharmadasa 23 October 2019, 12:25

View original

5 replies

Userlevel 7
Badge +19

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

Userlevel 4
Badge +8

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?

Userlevel 7
Badge +19

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')

Userlevel 7
Badge +19

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')

Userlevel 7
Badge +20

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