How to implement oracle single sign-on with a legacy application
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
Software/Hardware used:
Software/Hardware used:
ASKED:
July 14, 2009 11:55 AM
UPDATED:
July 31, 2009 3:44 PM
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
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.