Lets continue with yesterday’s post
http://becomeappsdba.blogspot.com/2007/01/configure-sso-for-apex-application.html

Make sure you have configured Partner Application in Single Sign-On Server as mentioned in previous post.
Unlock flows…. schema
SQL> alter user flows_020200 account unlock; (If your Apex version is 2.0.0.0.0 change acccordingly)

Login to Middle tier $ORACLE_HOME/sso/lib
unzip ssosdk902.zip
This will create packages directory & respective sql scripts in this directory connect as database user flows_020200 & execute loadsdk.sql
SQL>@loadsdk.sql (Make sure you are executing under schema flows_XXXX) This will load software development kit for sso server

Now register sso details in Apex Schema (flows_XXX)
SQL> @regapp.sql
It will prompt you for
Enter value for listener_token: Enter any distinct name like Apex:host_name:port
Enter value for site_id: enter_value_returned_while_registering_sso
Enter value for site_token: enter_value_returned_while_registering_sso
Enter value for login_url: http: // apex_url_here/pls/orasso/orasso.wwsso_app_admin.ls_login
Enter value for encryption_key: enter_value_returned_while_registering_sso
Enter value for ip_check: N

Now configure authentication packages under flows_XXX schema

SQL> @custom_auth_sso.sql
SQL> @custom_auth_sso.plb

Finally lock flows_XXXX schema & grant execute permission to public user
SQL> alter user flows_020200 account unlock;
SQL> grant execute on wwv_flow_custom_auth_sso to APEX_PUBLIC_USER;

Finally in Apex Application, create new authentication scheme (SSO with Apex as partner Application) instead of local database authentication in Apex Application.

configuration steps are mentioned at
http://becomeappsdba.blogspot.com/2007/01/configure-sso-authentication-schemes-in.html

http://teachMeOracle.com/forum

Previous in series Next in series

Related Posts for Apex


  1. Install Apex (Application Express) Formerly HTMLDB
  2. Configure SSO for Apex Application
  3. Apex Apps configure SSO II
  4. Configure SSO authentication Schemes in Apex
  5. Oracle Apex Architecture and configure Apex using embedded PL/SQL gateway

Popularity: 7% [?]

Share This