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'

No comments:

Post a Comment