Re: Allowing a user remote client AND local access

From: Joseph Li <lijoecyn_at_netspace.net.au>
Date: 2000/07/06
Message-ID: <3964F50A.970522D3@netspace.net.au>#1/1

I think I have tried this a few years ago.

OS authenticated user means OPS$, say the actual username is ops$u1 . So on the Solaris box the user logs into UNIX as u1, then type sqlplus / from the shell prompt.

However the oracle user ops$u1 can also have a password ie. SQL> alter user ops$u1 identified by ...

rgds

Christopher Burke wrote:

> I have made a user that has OS authenticated local access to Oracle (8 on
> Solaris 7).
>
> I have another user that has SQL authenticated client access to Oracle from
> a Windows 2000 computer (running oracle client tools) to the solaris box.
>
> My question is how do I get the OS authenticated user to log in remotely,
> the OS password doesn't work in the client software.
Received on Thu Jul 06 2000 - 00:00:00 CDT