Skip to Main Content
  • Questions
  • Single Sign on ( SSO ) in Oracle Apex


Question and Answer

Connor McDonald

Thanks for the question, ASHISH.

Asked: June 22, 2016 - 7:41 pm UTC

Answered by: Connor McDonald - Last updated: July 01, 2016 - 2:27 am UTC

Category: Developer - Version: 1

Viewed 10K+ times! This question is

You Asked

Hi Tom ,

I am suffering in implementing Single Sign on ( SSO ) in Oracle apex using Custom authentication scheme.
i have two applications like
 <b> App id</b>  <b> Application Name</b>
            101     -             Sample 1
            102     -             Sample 2

I want to apply SSOn on these application , here i have a single custom authentication scheme for these applications where data comes from a table like username and password.Table structure is --
<b>id</b>    <b>username</b>    <b>wrapped Password</b>
                  1001      Ashish1001       jjjsgghgsyyg2323gh2
                  1002      Sahay1002        llokokdjkh8989djdkk

My authentication scheme validates the dats from the table then allow to login for both the applications.but i have some users those having access on both applications then how can i allow to some logs in one application (Sample 1) and no need to login into Sample 2.
We actually have some links in both the applications from where user can navigate both the applications.If user logs into one application then he can just navigate to another application , o need to login again for another application,
If some one logs out from one application then another application should logout as SSO works.

Please helping me in this problem.

and we said...

My friend Scott has a nice blog post on this.

Hope this helps.

and you rated our response

  (2 ratings)

Is this answer out of date? If it is, please let us know via a Review



June 23, 2016 - 3:49 pm UTC

Reviewer: ASHISH SAHAY from India

HI Tom ,

The suggestion you have given is good and useful, But the main issue is we have link of both the apps like Link list.
When i click on link then the user logs out in both applications .

Chris Saxon


June 24, 2016 - 2:13 am UTC

"But the main issue is we have link of both the apps like Link list. "

Sorry - I dont understand what you are saying here.

Single Sign On ( SSO )

June 30, 2016 - 5:17 pm UTC

Reviewer: ASHISH SAHAY from India


I mean Every Application is having a link list that have home links of both the application "f?p=102" and "f?p=103", when i logged into one application say as f?p=102 ,
Now if i run another application "f?p=103" from WORKSPACE it follows SSO and the application does not require to login.
"But the main issue is " when i click on the link created in every application link list it does not follows SSO now i do not under stand what to do for this kind of SSO.
Chris Saxon


July 01, 2016 - 2:27 am UTC

That's getting outside my area of expertise.

Probably the best place to ask would be the apex forum

Hope this helps.