How to implement oracle single sign-on with a legacy application
Home > IT Answers > Oracle > How to implement oracle single sign-on with a...
Fostdolyn
15 pts.
0
Q:
How to implement oracle single sign-on with a legacy application
Oracle administration, SQLPlus, Legacy applications, Oracle connectivity, Single sign-on
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
ASKED: Jul 14 2009  11:55 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Meandyou
1840 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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.
Last Answered: Jul 30 2009  3:53 PM GMT by Meandyou   1840 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Fostdolyn   15 pts.  |   Jul 31 2009  3:44PM GMT

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.

 
0