Fusion HCM --Need help with a sql query for Fusion users , roles and the orgs the user has access [message #625324] |
Sun, 05 October 2014 10:37 |
![](http://www.gravatar.com/avatar/85a2fe22c96dc92b5634c0c4b280b448?s=64&d=mm&r=g) |
amita.narayanswamy
Messages: 2 Registered: October 2014
|
Junior Member |
|
|
Hi,
I need to write a sql query to pull out the USERS,ROLES and the Departments that a user via the ROLE has access to..
First query I worte -- I was able to pull out all active users and the ROLES attached to the USERS
Second query--Gets all the USERS AND the Departments that the users have access to
For Example If a USER HAS THE ROLES HR SPECIALIST ATTACHED THEN HE HAS ACCESS TO "DEPT_NAME_XYZ" and MY query should get this suername , role_name and the Dept Name..
This in the front end is happening via the person EIT--"DEPT_NAME_XYZ" is attached to this person record in the application.
However I need to get the connection between the USERS, ROLES and the DEPARTMENTS..
My query should pull out this..
Any help is appreciated..
Thanks.
|
|
|