Sure.
 
Just declare these in your init.ora
 
os_authent_prefix=OPS$
remote_os_authent=TRUE
 
bounce the database, add a user called OPS$<the Windows username>, e.g. OPS$AK if your Windows login id is AK as
 
create user ops$ak identified externally
 
From windows connect as "/@servicename", e.g. sqlplus /@service1
 
If it doesn't work, the OS user may be different. Use this query while connected to the database from Windows cleint.
 
SQL> select sys_context('USERENV','OS_USER') from dual;
 
See what OS username comes up; use that instead.
 
HTH.
 
Arup Nanda
www.proligence.com
 
 
----- Original Message -----
From: AK
Sent: Thursday, June 19, 2003 1:10 PM
Subject: oracle authentication from windows

We want our client users ( forms user )  to just enter windows password and then automatically able to get in to oracle .Is there a way oracle can authenticate from windows ( or active directory ) . enbadding password in runform.exe not an option .
 
thanks,
-ak

Reply via email to