| Apex Apps configure SSO II |
| Tuesday, January 09, 2007 |
|
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.htmlLabels: apex, sso |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
 del.icio.us
¦
 Digg This
¦
 My Yahoo
¦
 Reddit
¦
 BlinkList
¦
 Furl It
¦
Email This
¦
Leave Your Comments
|
posted by Atul Kumar @ 10:03 PM
  |
|
| 1 Comments: |
-
Good node on installation of APEX, still more things can be expalined about pre-req XML DB etc..
|
| |
| << Home |
| |
|
Good node on installation of APEX, still more things can be expalined about pre-req XML DB etc..