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 and later
Oracle Forms for OCI - Version and later
Information in this document applies to any platform.


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).


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

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