哪位有 user - responsibility 权限对应的查询 script?

hphubei

最初由 cooler 发布
[B]select fnd_user.user_id,
       fnd_user.user_name,
       fnd_responsibility_tl.application_id,
       fnd_responsibility_tl.responsibility_id,
       fnd_responsibility_tl.responsibility_name
  from apps.fnd_user,
       apps.fnd_user_resp_groups,
       apps.fnd_responsibility_tl
where fnd_user.user_id = fnd_user_resp_groups.user_id
       and fnd_user_resp_groups.responsibility_id = fnd_responsibility_tl.responsibility_id
       and upper(fnd_user.user_name)='xxxx' [/B]

这个是正解之一，多谢 Cooler

zhanglinjun007

都是答案!!