|
|
|
|
| Re: Read URL Header in forms [message #569517 is a reply to message #569482] |
Mon, 29 October 2012 01:23   |
harpreetsinghkup
Messages: 52
Registered: May 2006
Location: Mumbai
|
Member |
|
|
Hi,
We are migrating oracle forms 6i to form 11g. We want to incorporate SSO functionality for 11g application but as per company policy we can't use oracle provided SSO functionality.
Now coming to point.
Because, my application is written in this manner, each user is logging to forms as solitary oracle user and we are managing user's menu level right via oracle roles.
We have SSO URL (http://example.com), after users authentication it is providing users id in URL's header. Now we have to grab these user ids and login to oracle forms. As of now, we are not aware how to read this header via forms?
Hoping we have provided sufficient information. Please advice.
Regards,
Harpreet Singh
|
|
|
|
|
|
| Re: Read URL Header in forms [message #569934 is a reply to message #569524] |
Sat, 03 November 2012 05:48 |
harpreetsinghkup
Messages: 52
Registered: May 2006
Location: Mumbai
|
Member |
|
|
Hi,
I have found the way to handle this.
1. Use sys.UTL_HTTP package and you can read header of URL. The basic requirement for UTL_HTTP package is xml db instalation. Ask to your dba if that is not present.
2. You can use a middle layer(JSP/JAVA etc) which can read url header and within jdbc connection that can be fetch into oracle database.
example : I have my company's SSO site, After athorizaton it is redirecting to my new layer (JSP) page. JSP page can be deplyed via weblogic admin console as a war file. Now
1. JSP is reading all the parameters i.e. username/session_id. and i am performing my oprations accordingly.
2. In there is one perdefined string called &otherparams which helps us lot here. We can get any parameter via jsp and redirect it into forms url like below.
http://hostname:8888/forms/frmservlet?config=abc&otherparams=SESSION_ID=123
Enjoy
Harpreet Singh
[Updated on: Sat, 03 November 2012 05:54] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
