OraFAQ Forum: Forms » Oracle forms Kerberos authentication

Home » Developer & Programmer » Forms » Oracle forms Kerberos authentication (oracle forms 12c windows 2012)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle forms Kerberos authentication [message #661600]

Fri, 24 March 2017 11:40

marinab
Messages: 8
Registered: March 2017

Junior Member

Hi,
we have oracle databases 12c on windows 2012 configured with Kerberos authentication. oracle client 12c and sqldeveloper 4.1.5 are working perfect. The application designed in oracle forms. we planning move to 12c and I need Kerberos authentication in connection.
I found java code connect to oracle database using jdbc thin driver connection. It is working perfect. How I can use this connection into oracle forms.
Please help
Thanks Marinab

Report message to a moderator

Re: Oracle forms Kerberos authentication [message #661605 is a reply to message #661600]

Fri, 24 March 2017 13:12

BlackSwan
Messages: 26763
Registered: January 2009
Location: SoCal

Senior Member

Do you have configuration similar to below?

EndUser<=>browser<=>webserver<=>ApplicationServer<=>DatabaseServer

If so, "forms" never talks directly to Oracle DB

Report message to a moderator

Re: Oracle forms Kerberos authentication [message #661606 is a reply to message #661605]

Fri, 24 March 2017 13:21

marinab
Messages: 8
Registered: March 2017

Junior Member

yes, I have
what is your suggesting?
What should I change?
marinab

Report message to a moderator

Re: Oracle forms Kerberos authentication [message #661607 is a reply to message #661606]

Fri, 24 March 2017 13:47

BlackSwan
Messages: 26763
Registered: January 2009
Location: SoCal

Senior Member

marinab wrote on Fri, 24 March 2017 11:21

yes, I have
what is your suggesting?
What should I change?
marinab

I do NOT understand what problem you are trying to solve.
JDBC is used by some clients to connect (CREATE SESSION) to Oracle database.
In the 3-tier architecture it is the application server which logs into the Oracle database.
IMO, the use of Kerberos only adds complication between application server & database server.
If you insist it must be included, please explain what benefit is gained by doing so.

Report message to a moderator

Re: Oracle forms Kerberos authentication [message #661609 is a reply to message #661607]

Fri, 24 March 2017 13:53

marinab
Messages: 8
Registered: March 2017

Junior Member

Ok,
Help me configure oracle forms 12c using Kerberos authentication.
I'm open for any suggestion.
marinab

Report message to a moderator

Re: Oracle forms Kerberos authentication [message #661612 is a reply to message #661609]

Fri, 24 March 2017 14:34

BlackSwan
Messages: 26763
Registered: January 2009
Location: SoCal

Senior Member

marinab wrote on Fri, 24 March 2017 11:53

Ok,
Help me configure oracle forms 12c using Kerberos authentication.

EXACTLY how, what, or where do you want, desire or expect Kerberos authentication to be used in 3-tier architecture below?

EndUser<=>browser<=>webserver<=>ApplicationServer<=>DatabaseServer

Report message to a moderator

Re: Oracle forms Kerberos authentication [message #661613 is a reply to message #661612]

Fri, 24 March 2017 14:52

marinab
Messages: 8
Registered: March 2017

Junior Member

Hi,
could be on webserver or on database server. Like I mention before, all components (client, webserver, database) on windows.
maybe some plugin I can use.
marinab

Report message to a moderator

Re: Oracle forms Kerberos authentication [message #661641 is a reply to message #661613]

Sun, 26 March 2017 11:22

marinab
Messages: 8
Registered: March 2017

Junior Member

Hi Guys,
I still open to any suggestion.
On Forms server I configured Kerberos client sqlnet.ora(put trace);
When I try login in form; Kerberos using "server user" authentication and connection to database;
I guess I need some Javascript called on-login trigger take username from login screen
and created KDC ticket on forms server and login to database using this account.
Please help
Marinab

Report message to a moderator

Previous Topic:	Dynamic Database link
Next Topic:	ole2 package 'saveas' .xml file to tab-delimited .txt file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 18 22:27:31 CDT 2021