This content has been marked as final. Show 9 replies
Could you please tell how "Role Inheritence" ( In the User management screen) can be found in sql query from a role which is assigned to a user.
But i could not find any clues from which I am able to get Role Inheritance which I can see in User Management screen.
Pls help on how to get a role and role inheritence in sql query.
Please follow user management guide from below links (search as Role Inheritance)
Could you please tell which table stores the data for Role Inheritence?
I belive you have to check FND tables from etrm.oracle.com side for can understand relation&integration etc.
I have the exact same question as you. Did you find any answers regarding the Role inheritance?
If you could let me know, I would appreciate.
Thanks so much.
in R12.1, you can use the Security Reports section to get this data:
select the following
Report Type: List of Roles/Responsibilities
For a given: User, enter user name
Regarding the underlying tables:
it's the WF_ROLE_HIERARCHIES
and a query would be something like that:
to_char(WRH.LAST_UPDATE_DATE, 'YYYY/MM/DD') LAST_UPDATE_DATE,
from WF_ROLE_HIERARCHIES WRH, WF_ROLES WR
where WRH.SUB_NAME = WR.NAME
and WR.ORIG_SYSTEM in ('FND_RESP', 'UMX')
connect by wrh.super_name = wrh.sub_name
start with WRH.SUB_NAME = 'UMX|JTY_DEFECT_TERR_MAINTENANCE'