Re: oracle authentication from windows

From: Arup Nanda <orarup_at_hotmail.com>
Date: Thu, 19 Jun 2003 12:04:16 -0700
Message-ID: <F001.005B566B.20030619114536@fatcity.com>

Sure.

Just declare these in your init.ora

<FONT face=Arial
size=2>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

<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

Original Message ----- <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: AK To: <A [EMAIL PROTECTED] href="mailto:[EMAIL PROTECTED]">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 Received on Thu Jun 19 2003 - 14:04:16 CDT