Hello Wisers,
I am trying to get a user access from client machine to the database using windows authentication. These machines are on workgroup.

I created a local user on client machine.

CREATE USER "<CLIENTMACHINENAME>\<USERNAME>" PROFILE DEFAULT IDENTIFIED EXTERNALLY

where os_authent_prefix parameter is null.

to test this i also created a local user (db machine)

CREATE USER "<DBMACHINENAME>\<USERNAME>" PROFILE DEFAULT IDENTIFIED EXTERNALLY.
on db machine this allows me to log into database
sqlplus /

but the same command doesnt work for client machine.

Please help!!!

Thanks in advance.