Re: OS authentication

Frank <fvanbortel_at_netscape.net> wrote in message news:<3E9471BE.7050409_at_netscape.net>...
> Didier wrote:
> > Hi,
> >
> > I'm trying to use the OS authentication :
> >
> > - Server : Oracle 8.1.7
> > - Client : ODP.NET 9.2 (and parallel Oracle client 8.1.7)
> >
> > I've configured the database server (remote_os_authent=true /
> > os_authent_prefix = "" and create the user with a role giving access
> > to the db objects - also connect and create session right).
> > When using sqlplus with 'sqlplus /_at_myalias', all works fine. When
> > trying an Open on an OracleConnection in .NET (with the connect string
> > : "user id=/; data source=myalias"), I become an exception with the
> > error ORA-01017 (wrong login/password). Using my connection
> > (OracleConnection) starting with an Oracle identified user works fine.
> > I'm probably missing something, could someone give me some hints
> > please ? (I'v also set in registry OSAUTH_PREFIX_DOMAIN to FALSE -as
> > string key).
> >
> > Thanks
>
> Now I know Gate$ considers every PC, connected to the web as his own,
> but do you have _any_ idea what OS user would be used?!?
> Neither do I, or does Oracle

Sorry to say so but this is not true. The user is the user currently connected to the system. And even in the Evil Empire users have names, albeit it might be just 'administrator'. To get this working the OP must have
sqlnet.authentication_services=(NTS) in sqlnet.ora on the server, or it won't work.

Regards

Sybrand Bakker
Senior Oracle DBA Received on Thu Apr 10 2003 - 09:31:05 CEST