Can OracleSession get LogonUsername and password from Windows 2000/XP logon info

[rstrand]

Is there a way to have Oracle Session get the User ID and Password that was used to login to Windows 2000 or Windows XP and use that for the LogonUsername and LogonPassword?

 

[Eric^2]

There is no way to get the password from the OS as that would be VERY insecure. If the Oracle client is loaded on the local machine, transparent authentication can pass the SID of the currently logged on user to the Oracle server for validation.

 

[Marco Kalter]

To connect with an externally identified user, you can simply omit the username and password. The database instance and account must be setup correctly of course:

• The OS_AUTHENT_PREFIX parameter must be set correctly (OPS$ by default).
  
• The REMOTE_OS_AUTHENT parameter must be set to TRUE if the database is accessed across the network.
  
• The account must be created/altered with the IDENTIFIED EXTERNALLY option.

------------------
Marco Kalter
Allround Automations

[This message has been edited by mkalter (edited 19 August 2003).]