How to create an operating system authenticated connection in SQL Developer
Last updated on DECEMBER 06, 2017
Applies to:Oracle SQL Developer - Version 1.5 and later
Microsoft Windows (32-bit)
The goal of this document is to show the user how to create an Oracle database connection in SQL Developer that is authenticated by the operating system (OS).
NOTE: This solution requires that you create groups in the Windows OS. How that is done will vary across Windows versions and types (for example: XP, Vista, 2003 Server). This note was prepared based on Windows XP Professional.
This is not the only means of creating an OS Authenticated connection to the database. For example, it is possible to use local password file if desired. And you can also opt to use an OS Authentication prefix (traditionally "OPS$"). However, these are not required minimums and therefore will not be addressed in this note. Further information on those options can be found in the notes referenced at the end.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms