Re: Hide Password in SQL Plus

Pankaj Soni (psoni_at_amp.com) wrote:
: Yes, make a clone ps called psa. Let ps be a sed script : which replaces "xyz/xyz" from output of psa with "**/**".

IMHO altering a system wide tool such as 'ps' is summat of a hack and is not desirable.

#1 - Consider ops$ accounts

#2 - Use what Unix gives you :

--snip--
#!/bin/sh

sqlplus << !
user/password
DML/DDL/stuff goes here
exit
!
exit 0
--snip--

#3 Use Oraperl.

IAP Received on Sat Sep 14 1996 - 00:00:00 CEST