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: 257

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

Related posts about Oracle

Related posts about oracleinternetdirectory