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.