O/S Authentication & SQL*Net

From: Stephen Turner <sturner_at_athena.mit.edu>
Date: 1996/12/10
Message-ID: <58k5f0$q5f@senator-bedfellow.MIT.EDU>#1/1

What I'd like to do is to set my Oracle user ID to have a password, AND set O/S authentication on in the server so that when logged on locally to the server machine I can connect so:

sqlplus /

but when connecting via SQL*Net I am forced to type my password.

What actually happens is that if I set a password for the Oracle user id, I cannot connect just using a '/' locally; and if I set the Oracle user to be identified externally, I cannot connect via SQL*Net.

The server is Oracle 7.1 running on a DEC Alpha under DEC OSF/1. The OS_AUTHENT_PREFIX is set as null. I DON'T want to set the remote authentication on for security reasons.

Steve Turner Received on Tue Dec 10 1996 - 00:00:00 CST