Oracle Windows uses external authentication (ops$) such that the Operating System user ID manages the authentication. Once logged-on to the OS, you can enter Oracle directly without additional authentication.
CREATE USER OPS$SCOTT IDENTIFIED BY TIGER;
OR
CREATE USER OPS$SCOTT IDENTIFIED EXTERNALLY; Assuming that Scott has logged onto the operating system,
Scott could enter SQL*Plus with or without a password:
sqlplus /
sqlplus scott/tiger
Create Oracle External users in Windows
================================
External users are easy to create in Linux because you need only create the user in /etc/passwd. It's a bit trickier in Windows:
1. Create the Windows user:
start --> settings --> control panel --> administrative tools --> computer management --> user
2. Add the new user to the Oracle group:
start --> settings --> control panel --> administrative tools --> computer management --> groups
3. Add user to OS Database Administrator:
start --> programs --> oracle home --> configuration and migration tools --> administration for windows NT --> OS database administrator
4. Add user to OS Database Operators:
start --> programs --> oracle home --> configuration and migration tools --> administration for windows NT --> OS database operators
5. Add user to OS Administrator:
start --> programs --> oracle home --> configuration and migration tools --> administration for windows NT --> OS administrator
6. Add user to OS Operators:
start --> programs --> oracle home --> configuration and migration tools --> administration for windows NT --> OS operators
7. Add os_authent_prefix=OPS$ to your initialization parameters (pfile or spfile) and bounce Oracle database, if necessary.
This should allow for Oracle Windows external user authentication.
http://www.dba-oracle.com/t_windows_external_user_authentication.htm