Re: Externally authentication / OS_AUTHENT_PREFIX for NT

In article <35330898.29582523_at_newshost.interact.net.au>,   granta_at_nospam.student.canberra.edu.au (Fuzzy) wrote:
>
> 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
> :-)
>

Logon to your NT machine using 'mrmagoo' username and when SQL PLUS gives the login box enter '/' for username and the database alias for the host string.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Apr 14 1998 - 10:06:11 CDT