Hello Team,
Is there any database table or view in FND where permission set grant structure details are present.
Solved
Permission Set Grant Structure
Best answer by Thushitha Chandrasiri
Hi
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,
This topic has been closed for replies.
+10hi
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
Nimesh | www.linkedin.com/in/nimeshkasun | www.twitter.com/NimeshKasun
+21Hi
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,
Thushitha Chandrasiri - Follow my LinkedIn profile and contact me via - https://www.linkedin.com/in/thushitha-a-chandrasiri-32a2b2134/
hi
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
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.
fnd_role_content WHERE object_type = ‘ROLE’
Here is what you want if you need to see the child items in a permission set structure.
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.