Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: help connecting to oracle via javascript with osauthent
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