Search This Blog

Saturday, November 25, 2017

User Roles Query

select papf.person_number,
--pu.username,
prd.role_common_name
 from
 per_users pu,
 per_user_roles pr,
 per_roles_dn prd ,
 per_all_people_f papf
 where 1=1
 and papf.person_id = pu.person_id
 and pu.user_id = pr.user_id
 and pr.role_id = prd.role_id
--and papf.person_number = '119802'
 --and prd.role_common_name ='PAYROLL_SPECIALIST_DATA'

2 comments:

  1. Nice blog Thanks For Sharing This Informative Blog, In This Blog content is very informative.
    Oracle Fusion Financials Online Training
    Oracle Fusion SCM Online Training

    ReplyDelete
  2. Thanks for sharing this great information I am impressed by the information that you have on this blog. Same as your blog i found another one Oracle Project Portfolio Management Cloud. Actually, I was looking for the same information on internet for
    Oracle PPM Cloud Training and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject, you can learn more about Oracle Cloud Applications
    .

    ReplyDelete