Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!cornell!uw-beaver!sumax!polari!sparta!midkiff
From: midkiff@Thalatta.COM (Michelle Midkiff)
Newsgroups: comp.databases
Subject: Re: Accessing ORACLE from a diskless workstation
Keywords: Oracle, TCP/IP, TWO_TASK
Message-ID: <1224@sparta.Thalatta.COM>
Date: 3 Aug 89 20:18:48 GMT
References: <1989Aug3.034215.26877@comp.vuw.ac.nz>
Reply-To: midkiff@Thalatta.COM (Michelle Midkiff)
Organization: Thalatta Corporation, Bellevue WA
Lines: 33

In article <1989Aug3.034215.26877@comp.vuw.ac.nz> bernd@comp.vuw.ac.nz (Bernd Gill) writes:
>We are running an Oracle database on a server (called "depot", an HP370
>running HPUX). A number of diskless workstations (HP340's) are served
>over TCP/IP.
>
>If I am logged on to a diskless workstation the only way to connect to
>the database on the server is:
>	sqlplus username/password@T:depot:A
>
>This works fine, but if anybody else who is logged on to the same
>workstation runs "ps -ef" my password is displayed.
>This is an unacceptable security risk.
>
>Does anybody know a different way to connect to the database without
>having the password on the command line?
               << some text deleted for brevity >>


Set your TWO_TASK environment variable.  For example, in a c-shell you would
type:
               setenv TWO_TASK T:depot:A

Then when you try to connect to the database on the server, Just type:

               sqlplus

Oracle will bring up the login screen, which prompts for your login name and
password. 

-- 
-----------------------------------------------------------------------
In-Real-Life: Michelle Midkiff, Thalatta Corporation, (+1 206 455 9838)
Domain: midkiff@Thalatta.COM    Path: ...!sun!sunup!thebes!midkiff