I am trying to get Windows Authentication working for one of my databases.

The database which I am experimenting with is on my own PC but ultimately I
will want to do this on a database held on a server.

Here is what I did:

1) I added my network userid (extonbn) to the group ORA_DBA on my PC
2) Edited my init.ora file and included a line: os_authent_prefix=''
3)Stop/started my database.
4) Via a command prompt I set my ORACLE_SID variable to BRETT, which is the sid
name of my database
5) Logged into my database as sys and created a new user:

create user extonbn identified externally;
grant create session to extonbn;

6) Exited out of SQLPLUS back to cmd prompt and then ran:

=========
C:\>sqlplus /@BRETT

SQL*Plus: Release 9.2.0.6.0 - Production on Fri Mar 31 11:14:00 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

ERROR:
ORA-01017: invalid username/password; logon denied

Enter user-name:
=========

Any ideas what I've done wrong ??

Cheers

Brett


________________________________________________________________________
This e-mail and any attachments transmitted with it represents the
views of the individual(s) who sent them and should not be regarded
as the official view of Bridgend County Borough Council. The contents
are confidential and intended solely for the use of the addressee. If
you have received it in error, please inform the system administrator
on (+44) 01656 642111.

This e-mail and any attachments have been scanned with 'MessageLabs SkyScan' - http://www.messagelabs.com/

________________________________________________________________________
Maer'r e-bost hwn ac unrhyw atodiadau a drosglwddir gydag ef yn cynrychioli
safbwyntiau'r unigolyn (unigolion) a'u hanfonodd ac ni ddylid eu hystyried fel
safbwynt swyddogol Cyngor Bwrdeistref Sirol Pen-y-bont ar Ogwr. Mae'r cynnwy
syn gyfrinachol ac wedi'i fwriadu at ddefnydd y person y'i cyfeiriwyd ato yn
unig. Os ydych wedi ei dderbyn mewn camgymeriad, rhowch wybod i weinyddwry system ar (+44) 01656 642111.

Mae'r e-bost hwn ac unrhyw atodiadau wedi cael eu sganio gyda 'MessageLabs SkyScan' - http://www.messagelabs.com/
________________________________________________________________________

Oracle LazyDBA home page