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

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 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

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’

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