Solved

Is there a way to get a list of all the permission sets assigned to a user?

  • 25 October 2019
  • 4 replies
  • 1035 views

Userlevel 2
Badge +6

I would like to get a list of all the permission sets that have been assigned to a user, whether directly or indirectly. I can currently get a list of the directly linked permissions but we have some permission sets that are made up of other permissions.

 

e.g.

 

 

If a user has been assigned this permission I can see:

User: BLOGGS

FND_ROLE: BA_BARS_ADMIN

 

What I would like to see is:

User: BLOGGS

FND_ROLE: BA_BARS_ADMIN

FND_ROLE: FND_RUNTIME

 

Is this possible?

 

icon

Best answer by Pawel Lenczewski 25 October 2019, 15:45

View original

4 replies

Userlevel 5
Badge +5

Hi Helen,

You would need to either use a query with connect by clause or utilise view FND_USER_ROLE_RUNTIME (it may need for security cache to be refreshed after any changes).

 

Thanks,

Pawel

Userlevel 6
Badge +18

@Helen Smith  Pawel’s answer above is likely best for your situation, but you could also use the “Security per User” report.  This will also show all of the permission sets granted directly and indirectly to a user, but it will also include all of the objects granted to each of those permission sets.

It looks like the extra information will probably be too much for your requirement here, but it might help others who are trying to get the full list of permission sets so they can then identify what objects are actually granted.

Nick

Userlevel 6
Badge +15

You could use the view fnd_role_role which may be easier to read as it shows the link between End User Role and Functional Role.

select
a.grantee "User",
a.granted_role "End User Role",
(select listagg(b.granted_role, ', ') WITHIN GROUP (ORDER BY b.grantee) from fnd_role_role b where b.grantee = a.granted_role and b.grantee_type = 'ROLE') "Functional Role(s)"
from fnd_role_role a
where a.grantee_type = 'USER'
order by a.grantee, a.granted_role asc

 

 

 

Whereas just using the FND_USER_ROLE_RUNTIME view alone would give you the following which does not show the structure

 

Userlevel 6
Badge +9

You can query the user window from the username as follows (Create User → Search -> Summary Tab). This should list down all permission sets granted to the user

Reply