CODEWITHSUNDEEP
oracle-databasesingle-sign-onoracle-apex
adelmora
adelmora

Reputation: 53

Oracle APEX Single-Sign On

I have the following problem: I have two Oracle Apex applications, each of them having its own log in and own database scheme. To make it easier for the enduser I would like to implement a Single-Sign On. Meaning, the user needs just one username and one password in order to log in into both applications.

In App A all user information is stored. The same user information should be accessible by App B. The two applications have different workspaces. I am using APEX 4.2

How could I solve that problem?

Thanks for your answers.

Greetings from Germany

Admelo

Upvotes: 2

Views: 3185

Answers (1)

Dmitriy
Dmitriy

Reputation: 5565

First, I can recommend to move one of applications to another workspace, development will become easier. If it impossible, you can allow one workspace to see objects of another workspace. Log in to APEX internal workspace, go to Manage Workspaces - Manage Workspace to Schema Assignments, and add desired schema to workspaces.
To share login data. It depends on authentication scheme of both applications:

  • if you have scheme Database user in both applications, users can login in both applications right now
  • if you have scheme Application Express Login - you have to move applications to one workspace
  • if you have custom scheme - solution depends on scheme's implementation.

Upvotes: 2

Related Questions