Skip to main content
Solved

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

  • October 23, 2019
  • 5 replies
  • 520 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

View original
Did this topic help you find an answer to your question?

5 replies

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

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)
  • 30 replies
  • 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+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')


Rusiru Dharmadasa
Superhero (Employee)
Forum|alt.badge.img+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')


dsj
Superhero (Partner)
Forum|alt.badge.img+22
  • Superhero (Partner)
  • 844 replies
  • 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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings