Oracle EBS-SQL (SYS-23):用户权限查询.sql

select b.user_name,

         b.description,

         b.creation_date,

         d.responsibility_name   from fnd_user b,

         fnd_user_resp_groups   c,      

         fnd_responsibility_tl  d  

where b.end_date is null   

   and b.user_id=c.user_id   

   and c.responsibility_id=d.responsibility_id   

   and d.language='ZHS'

 order by b.user_name

转载于:https://www.cnblogs.com/st-sun/p/3778008.html