RE: oracle authentication from windows

[Gogala, Mladen]

That, of course, will render your database totally insecure and open to anybody who can bring in a WinXP laptop, change the windoze username and log in as he pleases. DBA that sets his production parameters the way Arup described deserves to be publicly tortured by Bill O'Reilly in the "no spin zone".   Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -----Original Message----- From: Arup Nanda [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 3:46 PM To: Multiple recipients of list ORACLE-L Subject: Re: oracle authentication from windows 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 To: Multiple recipients of list ORACLE-L 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