Re: O/S Authentication & SQL*Net

sturner_at_athena.mit.edu (Stephen Turner) wrote:

>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

Steve,

        What we have done here is set os_authent_prefix to OPS, so userids are created with ops$xxxxx. You would assign a password when you create the id. With this setup, you can do sqlplus / local and login in from a remote with ops$xxxxx/pwd. I'm not sure why setting the prefix to something other than null allows this type of login, but it does work. Also, make sure that remote_os_authent is set to false to stop sqlplus /@tnsalias.

HTH, Frank Received on Mon Apr 14 1997 - 00:00:00 CDT