Oracle EBS 基础概念：职责

通过创建用户并将用户与一个或多个责任相关联来实现安全性控制。

职责指定了实际的访问权限。
必要组件：数据组，菜单
可选组件：请求组，排除

SQL：职责已分配给哪些用户

select (select user_name from fnd_user where user_Id = A.user_id) User_name
      ,(select description from fnd_user where user_Id = A.user_id) User_description
      ,B.responsibility_name
      ,A.responsibility_application_id
      ,A.start_date
      ,A.end_date 
from FND_USER_RESP_GROUPS_DIRECT A,
     FND_RESPONSIBILITY_VL B
where (A.end_date is null or A.end_date >= sysdate)
  and A.responsibility_id =  B.responsibility_id
  and B.responsibility_name = 职责名称