Disabling Single Sign-On on Report Server

While accessing a 10g Application Server report, the user need to log-in through Single Sign-on process.

Though this is an additional security feature, someone may feel this annoying.

In this Post, I'll explain, how to avoid single sign-on process while accessing 10g AS reports.

Step 1: Disable Single Sign-on:
Uncomment the SINGLESIGNON parameter in the Reports Servlet configuration file (rwservlet.properties) and set it to "NO". This file is located in $ORACLE_HOME/reports/conf directory.

Note: The SINGLESIGNON value is usually commented out after installation, but the default value is YES.

Step 2: Disable Reports Server Security:

Though, the single sign-on is disabled, we need to sign-on at "reports server security" process, in order to access the reports.
To disable this, the security element in the Reports Server configuration file, ($ORACLE_HOME/reports/conf/servername.conf) must be commented out.


The default value would be like this:

"security id="rwSec" class="oracle.reports.server.RWSecurity>"

"!--property name="securityUserid" value="portal_id/portal_password@portal_schema" 

confidential="yes" encrypted="no"-->"

"property name="oidEntity" value="%REPORTS_OID_ENTITY%" confidential="yes" 

encrypted="no"/>"

"/security>"

Commenting out the above security element will disable the Reports server security process.

Step 3: Restart the report server opmn process.

That's all...

You won't get any annoying screen, asking for username and passwords.

But remember, you are reducing an additional security feature.