RE: oracle authentication from windows

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

<SPAN
class=484330519-19062003>publicly tortured by Bill O'Reilly in the "no spin zone".
 
Mladen Gogala <FONT face=Arial
size=2>Oracle DBA Phone:(203) 459-6855
Email:[EMAIL PROTECTED]

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Arup Nanda   [mailto:[EMAIL PROTECTED]Sent: Thursday, June 19, 2003 3:46   PMTo: Multiple recipients of list ORACLE-LSubject: 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="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">

• Original Message ----- <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: AK

    To: <A
    href="mailto:[EMAIL PROTECTED]" [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 - 14:41:45 CDT