Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1367
  • Last Modified:

How to connect to Oracle DB via OS Authentication

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.
0
boucherc
Asked:
boucherc
  • 2
1 Solution
 
sujith80Commented:
See this link, It has the step by  step instructions to setup OS level authentication.

http://www.oracle-base.com/articles/misc/OsAuthentication.php
0
 
bouchercAuthor Commented:
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?
0
 
sujith80Commented:
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 /
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now