Author Topic: Accept Windows Authentication for Oracle Repositor  (Read 1230 times)

PeterHeintz

  • EA User
  • **
  • Posts: 867
  • Karma: +52/-18
    • View Profile
Accept Windows Authentication for Oracle Repositor
« on: June 06, 2006, 11:29:54 pm »
Hello,
I scanned the topics regarding this issue but those did not give me a clear indication if the feature works for oracle or not. At least I do not get it work.

I changed my System User Login in the EA Oracle repository to DOMAIN\MYUSERNAME and I expected the feature to work but it does not.
What about the System User password? Shall it be the same as the Windows password or does it not give a damn about that issue?
Are any other thinks I have to care about?
???
Best regards,

Peter Heintz

«Midnight»

  • EA Guru
  • *****
  • Posts: 5651
  • Karma: +0/-0
  • That nice Mister Grey
    • View Profile
Re: Accept Windows Authentication for Oracle Repos
« Reply #1 on: June 07, 2006, 04:24:00 am »
Oracle maintains its own authentication system. You will have to enter your password, and perhaps your username. [It might be possible to have this default to the current login name, but I'm not sure if you can do it via EA.]

There are optional Oracle products that enhance the strength of their security, depending on the version of Oracle (I think very recent versions may come with enhanced security built in). I do not think these provide integration with Windows security, nor do I think there is any difference in login procedures for the end user, but I am not sure.

Depending on your Oracle settings, and additional settings in the OLEDB connection string, it may be possible to enter your username and/or password automatically. This is not advisable on a network, as these are transmitted in clear text. [Note that the .Net provider for Oracle might provide encryption; you will have to check the documentation.] Otherwise, you will have to choose from several levels of security offered by Oracle. Each level results in slightly different, but very predictable, behaviour during connection.

Check the Oracle documentation. It used to be a bit difficult to find, but they have improved navigation, so it should be easier now.

HTH, David
No, you can't have it!

StefanPears

  • EA User
  • **
  • Posts: 119
  • Karma: +6/-0
  • Unwissenheit schützt vor Erkenntnis nicht
    • View Profile
Re: Accept Windows Authentication for Oracle Repos
« Reply #2 on: June 07, 2006, 07:42:12 am »
Peter, we're using an oracle database either. I changes my login to domain\alias and my EA password to my windows password and that was it. No more EA login. Even changing my windows password later on did not affect the EAs login behavior.

If you have an alias, try it. And you have to watch for uppercase/lowercase carefully.

hth
Stefan