怎么查看系统里所有用户对应拥有的权限?

select c.user_name 登录名,
       nvl(c.employee_id, 0) 雇员ID,
       b.RESPONSIBILITY_NAME 职责名称,
       c.start_date 用户有效开始日期,
       c.end_date  用户有效结束日期,
       a.START_DATE 职责有效开始日期,
       a.END_DATE 职责有效结束日期,
       d.full_name 员工姓名,
       e.ASSIGNMENT_NUMBER 员工编号,
       f.name 部门名称
  from apps.FND_USER_RESP_GROUPS_DIRECT  a,
       apps.FND_RESPONSIBILITY_VL        b,
       apps.fnd_user                     c,
       apps.hr_employees                 d,
       apps.per_assignments_f            e,
       apps.hr_all_organization_units_tl f
where a.user_id = c.user_id 
   and a.RESPONSIBILITY_ID = b.RESPONSIBILITY_ID
   and c.employee_id(+) = d.employee_id
   and c.employee_id = e.PERSON_ID
   and e.ORGANIZATION_ID(+) = f.organization_id
   and f.language = 'ZHS'
   and sysdate between c.start_date and nvl(c.end_date, sysdate)
   and sysdate between a.start_date and nvl(a.end_date, sysdate)
   and sysdate between e.EFFECTIVE_START_DATE and
       nvl(e.EFFECTIVE_END_DATE, sysdate)
   and nvl(c.employee_id, 0) <> 0

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值