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