Posted By: sagizvi plsqldeveloper kerberos authentication - 06/01/09 06:43 AM
Hi.

We've managed to setup oracle advanaced security with kerb authentication. When i enter to plsqldeveloper without user/password but only with SID, it works well.

But i still got few issues:

1. Logon history
The user/password@db entry isnt being kept in the logon history.

2. Domain Authentication - using okinit
When the end user wants to login into the DB from a machine that isn't part of the domain - they need to activate a tool called okinit in order to authenticate to the right domain and get a kerberos ticket.
Only later on they can login without user/pass. That is a normal behaviour of Oracle Client, but still I would prefer if you guys could add to the login screen an option to authenticate to the domain itself , instead of activating the okinit tool before activating plsqldeveloper.
[quote=sagizvi]1. Logon history
The user/password@db entry isnt being kept in the logon history.[/quote]
We'll check it out and will fix it.

[quote=sagizvi]2. Domain Authentication - using okinit
When the end user wants to login into the DB from a machine that isn't part of the domain - they need to activate a tool called okinit in order to authenticate to the right domain and get a kerberos ticket.
Only later on they can login without user/pass. That is a normal behaviour of Oracle Client, but still I would prefer if you guys could add to the login screen an option to authenticate to the domain itself , instead of activating the okinit tool before activating plsqldeveloper.[/quote]
I have added this to the list of enhancement requests.
Posted By: sagizvi Re: plsqldeveloper kerberos authentication - 06/01/09 04:41 PM
thanks
Posted By: sagizvi Re: plsqldeveloper kerberos authentication - 06/01/09 04:46 PM
in the meanwhile i can configure the okinit as a "tool configuration".
Our clients are using a network drive for plsql binaries and configuration. is there a way to configure okinit for all of the clients from this single network location?
Yes, this is possible. You can copy the corresponding [ExternalTools]
section from your user.prefs file to the Preferences\Default\user.prefs file on the server. This way all new users will get these tools by default. For existing users you will need to copy the tool definition to their existing user.prefs file.
Posted By: mihi.jana Re: plsqldeveloper kerberos authentication - 10/03/22 01:10 PM
Hello,
can I ask you for instruction how to setup pl/sql developer to use kerberos authentication?
Thanks
Posted By: sagizvi Re: plsqldeveloper kerberos authentication - 05/20/23 12:32 PM
Marco. Did you add these features already ? It has been a few years now.
Which feature(s) do you mean specifically?
Posted By: sagizvi Re: plsqldeveloper kerberos authentication - 07/15/23 06:52 AM
this one:

Originally Posted by sagizvi
2. Domain Authentication - using okinit
When the end user wants to login into the DB from a machine that isn't part of the domain - they need to activate a tool called okinit in order to authenticate to the right domain and get a kerberos ticket.
Only later on they can login without user/pass. That is a normal behaviour of Oracle Client, but still I would prefer if you guys could add to the login screen an option to authenticate to the domain itself , instead of activating the okinit tool before activating plsqldeveloper.
I have added this to the list of enhancement requests.[/quote]
© Allround Automations forums