My Oracle Support Banner

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 APRIL 24, 2023

Applies to:

Oracle Forms - Version 11.1.2.1.0 and later
Oracle Forms for OCI - Version 12.2.1.4.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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.