I'm trying to use Windows OS authentication and having trouble, I
created a local Windows user ora_user

Then I changed OS_AUTHENT_PREFIX to '' and restarted the instance,
here's what happen

C:\Documents and Settings\ora_user>sqlplus sys/#### as sysdba



SQL*Plus: Release 10.2.0.1.0 - Production on Wed Apr 4 09:49:47 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.



Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options



SQL> show parameter OS_AUTHENT_PREFIX;



NAME TYPE VALUE

------------------------------------ -----------
------------------------------

os_authent_prefix string



SQL> create user ora_user identified externally;

User created.

SQL> quit

Disconnected from Oracle Database 10g Enterprise Edition Release
10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options



C:\Documents and Settings\ora_user>sqlplus /



SQL*Plus: Release 10.2.0.1.0 - Production on Wed Apr 4 09:50:05 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.



ERROR:

ORA-01017: invalid username/password; logon denied



Enter user-name:



What am I doing wrong? Is there a step I'm missing the get this to work?
Is there an OS group its need to belong to?



- John




Oracle LazyDBA home page