Here is what you want if you need to see the child items in a permission set structure. @Sunny fnd_role_content WHERE object_type = ‘ROLE’ Hello Shawn Berkstresser, Thanks for response, Yes, I am searching this only . Thank you So much. Sunny Ahuja
Hi @Sunny , you can use the view fnd_user_role to find which permission sets have been granted to a specific user/users. And you can use view FND_ROLE to find the details of permission sets (when it was created, which type it is ect..) And also you can use FND_GRANT_ROLE view to see to which permission sets a certain permission set/sets are granted in the structure. You can join these views to see some further analytical details. Thanks, Hello Thushitha Chandrasiri, Thanks for your response. Thanks,Sunny Ahuja
hi @Sunny, did you mean to find which permission sets are granted to which user and the permission details? If yes, you can find the answers here: /Nimesh Hello Nimesh, Thanks for your response, I need Database table or view, which has details of ( which permission sets a certain permission set/sets are granted in the structure). Thanks,Sunny Ahuja
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.