Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> single sign-on with client/server applications

single sign-on with client/server applications

From: Bruce McCartney <>
Date: Tue, 11 Jan 2005 20:40:53 -0700
Message-ID: <!~!>

Hello List,
Anybody got experience with this type of situation using Active Directory and VB? The requirement is for passwords to change periodically, an alternative is to expire the Oracle password but I was wondering if people are going to Oracle Internet Directory and synchronizing and are happy with the setup.  

Scenario 1
User logs into his PC via Active Directory. User chooses to start application X. Application X asks him to choose a database. Application X connects to chosen database. User does not need to provide his credentials again. Later on, user repeats the same procedure on application Y. Scenario 2
Continuing on from scenario 1, user chooses to start application Z. Application Z asks him to choose a database as well as giving him the option to connect using a different userid than his own. If user chooses a different userid, then he must provide a password.

1) Is possible to fulfill the above scenarios? 2) If so, can you tell us what additional software (from Oracle Corp. or otherwise) that we would need?
3) Can we have Active Directory be the "authenticating" server?

Operating environment
1) Oracle 8.1.6,, or 9.2 Enterprise Edition RDBMS hosted on AIX (4.3 or 5.1) servers.
2) Currently, using database authentication (accounts and roles created in each database).
3) Applications are home-grown client/server apps written in Visual Basic (VB6 and VB.NET).
4) Usually, each application connects to one and only one database. 5) The user determines which database to connect to during the login process.

6) The applications run on Windows 2000 client PCs.
7) Microsoft Active Directory used to login to the PCs.
8) Not running Oracle Application Server.
9) Not licensed for the Advanced Security Option.

TIA   Bruce McCartney

Received on Tue Jan 11 2005 - 21:36:26 CST

Original text of this message