How to implement oracle single sign-on with a legacy application

15 pts.
Tags:
Legacy applications
Oracle administration
Oracle connectivity
Single sign-on
SQLPlus
I have set up a user for external authentication in the database. I am able to login to the oracle database sqlplus /@dbname and it uses my windows account. But when I try to login to the application I get an error of a null password. Are there any other applications/tools that are necessary to implement this? How is the password passed to the application? Thanks in advance. Pguin

Answer Wiki

Thanks. We'll let you know when a new response is added.

Oracle has two methods of signon …
1) users and passwrods defined to the Oracle database as in CREATE USER username IDENTIFIED BY pass_word
2) users that Oracle will allow to be authenticated by the operating system as in CREATE USER username IDENTIFIED EXTERNAL
the second ones (used to) default to prefixing the userid with ‘OPS$’

you state “login to the application”. Well, at that exact moment, you really aren’t connecting to Oracle, you are executing a program. Is the program connecting to Oracle? Is that the exact moment you are getting the error? Then your app needs to do one of several things; connect to oracle passing the uid & pw that came into the program , connect with its own username (which needs to be defined to Oracle) , depending on the platform, you may have to have the program prompt the user for the Orcle username and password.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Fostdolyn
    Thanks Meandyou for your response. The user was created with external identification as in your example 2. The application is launched with app.exe -sso. The dsn was created through ODBC admin. The login to the app uses the last datasource connection as stored in the Registry. when not using SSO the login screen accepts username/password/dsn. So I am a bit stuck.
    15 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following