Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: help connecting to oracle via javascript with osauthent

Re: help connecting to oracle via javascript with osauthent

From: joel garry <joel-garry_at_home.com>
Date: 8 Aug 2006 16:57:47 -0700
Message-ID: <1155081466.925699.168970@i3g2000cwc.googlegroups.com>

Wyatt wrote:
> I'm trying to connect to an oracle 10g database with javascript using
> os authentication. For now, I'm running the script on the database
> host.
>
> Using sql*plus, I can connect with "connect / as sysdba"
>

D'Oh! I forgot to mention there has to be an OS user with the same name as the oracle user, the oracle user prefixed with OS_AUTHENTICATION_PREFIX. So if you have a login to the OS as Wyatt, there would have to be an oracle user name OPS$WYATT.

Note also you wouldn't want to have remote users from insecure operating systems using this.

jg

-- 
@home.com is bogus.
Once more into the breach.
Received on Tue Aug 08 2006 - 18:57:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US