Logging into oracle db as a global user
Posted
by kineas
on Stack Overflow
See other posts from Stack Overflow
or by kineas
Published on 2010-04-16T14:03:36Z
Indexed on
2010/04/25
8:13 UTC
Read the original article
Hit count: 286
We are trying to shape up an old, 2 tier, Delphi based application. It originally uses database authentication, we'd like to transform the db user accounts to global users, so an OID server could perform the authentication instead of the database.
The Delphi program can no longer log into the database if the account is a global user. I'm trying to understand the login protocol, so far without results.
Similar thing happens with SQLDeveloper, I can't connect as a global user. SQLPlus however works with both kinds of users. We checked the information flow with Wireshark. When the dbserver asks back for a password, the SQLPlus sends it, while the SQLDeveloper doesn't send a password when attempting to connect as a global user.
The client sends the application name too in the login request. Is it possible that we have to store the client app name in the LDAP itself?
© Stack Overflow or respective owner