How to connect to Oracle DB via OS Authentication

Posted on 2008-11-14
Last Modified: 2013-12-19
I have a client that I am setting ATG 2007.1 in JBoss 4.0.5. They have a security requirement that says we have to use OS authentication for connecting to the Oracle databases.

I know how to set up database-level users with JDBC connections, but do not know what measures I need to take to use OS level authentication. What changes in JBoss are required?

Just more information, both the JBoss app servers and the Oracle DB servers are running on Solaris 10 Sun SPARC servers.
Question by:boucherc
    LVL 27

    Expert Comment

    See this link, It has the step by  step instructions to setup OS level authentication.

    Author Comment

    Yes, I have this article bookmarked. However, how does one set up JBoss to access the Oracle server in this manner?

    The norm is with a data source xml file, which passes the username and password. How is this accomplished with the OS authentication method?
    LVL 27

    Accepted Solution

    You can pass the username as "/" and password as a null string. (remember to set your oralce SID in the env).

    I.e. you connect to sqlplus in this way from the os

    sqlplus /

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    Introduction A previously published article on Experts Exchange ("Joins in Oracle", makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
    How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
    Via a live example, show how to take different types of Oracle backups using RMAN.
    This video shows how to recover a database from a user managed backup

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now