Externally authentication / OS_AUTHENT_PREFIX for NT

Hi people,

I'm having difficulty getting external authentication to work on NT. The doco is about as useful as an umbrella in a hurricane.

The scenario.

I have a NT user called 'mrmagoo', with a password of 'mrmagoo'.

I set the environment variable OS_AUTHENT_PREFIX to "" - as this was the way the doco suggested a null value should be entered. (I tried leaving it blank, but NT just ignores e.v.'s with blank values).

I stopped the Oracle service, and restarted it.

I issued the command "CREATE USER MRMAGOO IDENTIFIED EXTERNALLY".

I then tried to login to SQL*Plus. No, can't do that, keeps asking for a password. If I give it the password mrmagoo, it gives the good old 01017 error.

I've tried setting OS_AUTHENT_PREFIX to "" in the init.ora file, but that didn't work either.

I'm off to try setting it to blank, but in the mean time any ideas?

Ciao
Fuzzy
:-) Received on Tue Apr 14 1998 - 02:03:16 CDT