How to create an operating system authenticated connection in SQL Developer (Doc ID 868802.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle SQL Developer - Version 1.5 to 4.0 [Release 1.5.0 to 4]
Microsoft Windows (32-bit)
Microsoft Windows
***Checked for relevance on 03-Jun-2014***


Goal

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.

Solution

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