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: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 08 Aug 2006 17:38:23 -0700
Message-ID: <1155083902.502764@bubbleator.drizzle.com>


joel garry wrote:
> 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

And by insecure operating systems ... read "Windows."

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Tue Aug 08 2006 - 19:38:23 CDT

Original text of this message

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