Skip to main content
Answer

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

  • October 23, 2019
  • 5 replies
  • 552 views

Peter.Buitenhuis
Sidekick (Former Employee)
Forum|alt.badge.img+8

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

Best answer by Rusiru Dharmadasa

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

5 replies

Rusiru Dharmadasa
Superhero (Employee)
Forum|alt.badge.img+20

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


Peter.Buitenhuis
Sidekick (Former Employee)
Forum|alt.badge.img+8
  • Author
  • Sidekick (Former Employee)
  • October 23, 2019

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?


Rusiru Dharmadasa
Superhero (Employee)
Forum|alt.badge.img+20

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


Rusiru Dharmadasa
Superhero (Employee)
Forum|alt.badge.img+20

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


dsj
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • October 23, 2019

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