Solved

Permission Set Grant Structure

  • 15 June 2021
  • 6 replies
  • 493 views

Userlevel 1
Badge +1
  • Do Gooder (Partner)
  • 3 replies

Hello Team,

 

Is there any database table or view in FND where permission set grant structure details are present.

icon

Best answer by Thushitha Chandrasiri 15 June 2021, 19:08

View original

This topic has been closed for comments

6 replies

Userlevel 6
Badge +10

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

Userlevel 7
Badge +18

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,

Userlevel 1
Badge +1

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

Userlevel 1
Badge +1

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

Userlevel 7
Badge +28

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’

Userlevel 1
Badge +1

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