Re: O/S Authentication & SQL*Net

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

We do this all the time. The 'trick' is that OS_AUTHENT_PREFIX must be set to 'OPS$'. If you set it to anything else, you get the behavior that you see.

So, you set OS_AUTHENT_PREFIX to 'OPS$'. You create the user normally, specifying a password (DO NOT use IDENTIFIED EXTERNALLY).

You can then log into the oracle account with a / from the OS account that matches it. When you log in from a client, you specify the Oracle ID (including the OPS$ prefix) and the password.

-- 
Bob Swisshelm
Eli Lilly and Company
swisshelm_at_lilly.com