Re: oracle authentication from windows

Got it . Thanks Arup .
<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: Arup Nanda

  To: <A [EMAIL PROTECTED]
  href="mailto:[EMAIL PROTECTED]">Multiple recipients of list ORACLE-L   

  Sent: Thursday, June 19, 2003 12:45
  PM
  Subject: Re: oracle authentication from   windows   

  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,
    <FONT face=Arial
size=2>-ak Received on Thu Jun 19 2003 - 15:00:30 CDT