My Oracle Support Banner

How to Obtain the SSO Username for a PL/SQL Application (Doc ID 269688.1)

Last updated on APRIL 07, 2022

Applies to:

Oracle HTTP Server - Version to [Release AS10gR2 to AS10gR3]
Oracle Application Server Single Sign-On - Version to [Release 10gR2 to 10gR3]
Information in this document applies to any platform.


To state and show an example of obtaining user information, (as a CGI environment 
variable), after logging on to a PL/SQL application that is protected via 
Single Sign-On (SSO). Thereafter, application developers may then use this
value within their code logic to direct an application to an area specific
to the user logging in.
The scope of this document is limited to how the SSO username is obtained
when using a PL/SQL application though Oracle HTTP Server, mod_plsql. It is
not within the scope of this document to detail the design and implementation
of how this username is then used by an application developer to produce
desired functionality around the user logged in.

Versions this is applicable to:

   Oracle Application Server 10g Release 2 (10.1.2)

   Oracle Application Server 10g Release 3 (10.1.3)


To view full details, 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 a vibrant support community of peers and Oracle experts.