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
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
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
Already have an account? Login
No account yet? Create an account
Enter your 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.