SQL*Plus Question

From: kv <krishnav_at_optonline.net>
Date: Thu, 14 Feb 2002 02:16:40 GMT
Message-ID: <c6Fa8.79755$th4.24998025@news02.optonline.net>

Hi
I am on Sun-Solaris Oracle 8i.

To log into SQL*Plus, usually I do the following:

define export variables for user, passwd and server
sqlplus $user/$passwd@$server

The problem with this approach is, as long as the SQL*Plus session is active, If any body does a ps-ef on the system, they will see my schema password. How can I prevent any body seeing my password and still be able to use the export variables to login to SQL*Plus. I donot want to enter pass word everytime I log into SQL*Plus?

Thanks
Krishna
Email: krishna_vemulapalli_at_hotmail.com Received on Wed Feb 13 2002 - 20:16:40 CST