Reports 11gR2 Using JPS Security: RW_ADMINISTRATOR Role Needs to Be Added Manually For Custom SSO Users Different Than orcladmin

(Doc ID 1590749.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Forms - Version 11.1.2.1.0 and later
Information in this document applies to any platform.

Goal

Why RW_ADMINISTRATOR should be added manually in Reports 11g R2 (11.1.2.X) when using JPS Security? It was not needed on Reports 11g R1 (11.1.1.X).

The only SSO User that is working fine out of the box is orcladmin.

The other custom SSO users need the RW_ADMINISTRATOR role to execute a simple report or the administrator URLs  (i.e., getserverinfo, showjobs, getjobid, showenv).
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms