ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Find Profile ~~

Find Profile ~~

原创 Linux操作系统 作者:leexiaodong 时间:2009-08-13 10:24:16 0 删除 编辑
SELECT pro.profile_option_name,      
       pro.user_profile_option_name,      
       lev.level_type TYPE,      
       lev.level_name,      
       prv.profile_option_value
  FROM apps.fnd_profile_options_vl pro,      
       applsys.fnd_profile_option_values prv,      
       (SELECT 10001 level_id,              
               'Site' level_type,              
               0 level_value,              
               'Site' level_code,              
               'Site' level_name       
          FROM dual       
        UNION ALL       
        SELECT 10002 level_id,              
               'App' level_type,              
               app.application_id level_value,              
               app.application_short_name level_code,              
               app.application_name level_name       
          FROM apps.fnd_application_vl app       
        UNION ALL       
        SELECT 10003 level_id,              
               'Resp' level_type,              
               resp.responsibility_id level_value,              
               resp.responsibility_key level_code,              
               resp.responsibility_name level_name       
          FROM apps.fnd_responsibility_vl resp       
        UNION ALL       
        SELECT 10004 level_id,             
               'User' level_type,              
               usr.user_id level_value,              
               usr.user_name level_code,              
               usr.user_name level_name       
          FROM applsys.fnd_user usr) lev
 WHERE pro.profile_option_id = prv.profile_option_id(+)     
   AND prv.level_id = lev.level_id(+)     
   AND prv.level_value = lev.level_value(+)
--参数Profile,下面连个条件用一个即可
-- AND pro.user_profile_option_name LIKE '%BNE Allow No Security Rule%' --Profile名称
 ORDER BY pro.profile_option_name, lev.level_type, lev.level_name;

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/67253/viewspace-612082/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 编译 PLL 文件
下一篇: XML 输出 EXCEL
请登录后发表评论 登录
全部评论

注册时间:2009-08-13

  • 博文量
    64
  • 访问量
    108448