Windows NT Native Authentication(NTS) using Direct=True mode

[kiritv]

I would like to use windows native authentication --SQLNET.AUTHENTICATION_SERVICES= NTS-- (provided that the same user exists as external in oracle) to avoid any password maintenance in client application. I would like to have this in appplication which connects to oracle database using direct mode to eliminate any oracle client requirement on client workstation. How do I do that.

[StanislavK]

Unfortunately, it is impossible to use OS authentication in Direct Mode.

For more information on Direct Mode limitations, please see our help, article "Using dotConnect for Oracle"."Using Direct Mode" at
http://www.devart.com/dotconnect/oracle/docs/ .

[kiritv]

May I ask you why it's impossible to enable direct mode with NTS authentication? I believe that will add huge value...

[StanislavK]

The OS authentication support highly relies on the OCI functionality, which can not be fully reproduced in Direct Mode.

[vdt]

what is the best in use :
- direct mode with specific user and password
or
- directMode=false and os authentification

[StanislavK]

The choice depends on security and functionality requirements for you application. The OS authentication may be unsecure, the Direct connection mode has some functionality limitations comparative to the OCI mode.

For more information on different Oracle authentication methods, please refer to the official Oracle documentation:
http://download.oracle.com/docs/cd/B193 ... mnauth.htm

Also, please see the corresponding topic of our help for details on abilities and limitations of the Direct mode:
http://www.devart.com/dotconnect/oracle ... tMode.html