{"id":8710,"date":"2016-12-09T09:16:47","date_gmt":"2016-12-09T14:16:47","guid":{"rendered":"https:\/\/pitss.org\/us\/?p=8710"},"modified":"2018-05-23T19:01:22","modified_gmt":"2018-05-23T23:01:22","slug":"secure-reports-showjobs-end-users","status":"publish","type":"post","link":"https:\/\/pitss.org\/us\/2016\/12\/09\/secure-reports-showjobs-end-users\/","title":{"rendered":"How to Secure Reports Showjobs from End Users"},"content":{"rendered":"

[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”3.0.51″ custom_padding=”0px||50px|”][et_pb_row custom_padding=”0px|||” admin_label=”Row” _builder_version=”3.0.51″ background_size=”initial” background_position=”top_left” background_repeat=”repeat”][et_pb_column type=”4_4″ _builder_version=”3.0.47″ parallax=”off” parallax_method=”on”][et_pb_text admin_label=”Text” _builder_version=”3.0.106″ custom_margin=”||30px|”]<\/p>\n

By default, if you were to access the showjobs page of yourReports 11g or 12c environment, any user is able to view the page and open up the reports even if they contain confidential information. There is a way you can configure the showjobs to wh ere only specific users can access this page or any of the Reports admin pages.<\/p>\n

[\/et_pb_text][et_pb_divider color=”#e2e2e2″ divider_position=”center” disabled_on=”on|on|off” admin_label=”Divider” _builder_version=”3.2″ custom_css_main_element=”margin-bottom:30px !important;”][\/et_pb_divider][et_pb_text admin_label=”Text” _builder_version=”3.0.51″ custom_margin=”||30px|”]<\/p>\n

What you’ll learn in this article:<\/strong><\/h3>\n

\u2713<\/strong>\u00a0Steps that work for 12c and 11g with screenshots<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row custom_padding=”40px|40px|30px|40px” background_position_1=”top_left” background_repeat_1=”no-repeat” admin_label=”Row” _builder_version=”3.0.51″ background_color=”#006bb3″][et_pb_column type=”4_4″ _builder_version=”3.0.47″ parallax=”off” parallax_method=”on” background_position=”top_left” background_repeat=”no-repeat”][et_pb_text admin_label=”Text” _builder_version=”3.0.106″ background_color=”#006bb3″ background_layout=”dark”]<\/p>\n

Fill out the form below to access this blog post.<\/strong><\/h2>\n

[\/et_pb_text][et_pb_code admin_label=”Code” module_class=”white-text” _builder_version=”3.3.1″][ninja_form id=42][\/et_pb_code][\/et_pb_column][\/et_pb_row][et_pb_row custom_padding=”0px||0px|” custom_margin=”30px||0px|” background_position_1=”top_left” background_repeat_1=”no-repeat” admin_label=”Row” _builder_version=”3.0.51″][et_pb_column type=”4_4″ _builder_version=”3.0.47″ parallax=”off” parallax_method=”on” background_position=”top_left” background_repeat=”no-repeat”][et_pb_cta title=”Avoid the Shadow App Mayhem” button_url=”https:\/\/pitss.org\/avoid-the-shadow-app-mayhem-transform-your-legacy-applications\/” url_new_window=”on” button_text=”LEARN MORE ABOUT SHADOW APPS” admin_label=”Call To Action” _builder_version=”3.3.1″ background_color=”#222222″ custom_button=”on” button_font=”Abel|||on|” text_orientation=”left” custom_padding=”45px|50px|45px|50px” border_style=”solid”]Is your IT team always chasing down shadow applications? You can keep your users happy by modernizing your legacy systems. Give users the tools to be more productive, all while updating and securing your internal systems.[\/et_pb_cta][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

By default, if you were to access the showjobs page of yourReports 11g or 12c environment, any user is able to view the page and open up the reports even if they contain confidential information. There is a way you can configure the showjobs to wh ere only specific users can access this page or […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"By default, if you were to access the showjobs page of your Oracle Reports 11g or 12c environment, any user is able to view the page and open up the reports even if they contain confidential information. There is a way you can configure the showjobs to where only specific users can access this page or any of the Reports admin pages (steps written for 12c but they will also work for 11g):\r\n

    \r\n \t
  1. Open up rwservlet.properties (make a backup first) located in $DOMAIN_HOME\/config\/fmwconfig\/servers\/WLS_REPORTS\/applications\/reports_12.2.1\/configuration.<\/li>\r\n \t
  2. Locate the line L2<\/webcommandaccess><\/strong>. Change L2<\/strong> to L1<\/strong>.\r\n
      \r\n \t
    1. L1 will only permit end users to use the non-admin rwservlet commands GETJOBID, KILLJOBID, SHOWAUTH, and SHOWJOBID<\/strong>.<\/li>\r\n \t
    2. \"rwservlet.properties\"<\/a><\/li>\r\n<\/ol>\r\n<\/li>\r\n \t
    3. Save and close the file.<\/li>\r\n \t
    4. Open up rwserver.conf (make a backup first) located in $DOMAIN_HOME\/config\/fmwconfig\/components\/ReportsServerComponent\/$rptsvr.<\/li>\r\n \t
    5. Near the bottom of the file, look for the line <\/strong>. Immediately after this line, add the following line:\r\n