Re: Hide Password in SQL Plus
From: Brian M. Biggs <bbiggs_at_cincom.com>
Date: 1996/09/20
Message-ID: <3242CBE8.78AC_at_cincom.com>#1/1
Date: 1996/09/20
Message-ID: <3242CBE8.78AC_at_cincom.com>#1/1
Dave Erwin wrote:
>
> You can use externally identified account (ops$) or do the following
>
> sqlplus /nolog -- start sqlplus but do not logon
> connect username/password -- logon
I used to do this on VMS, but under UNIX it doesn't look like SQL*Plus supports the /nolog parameter. Anyone else seen this?
I tried to use /nolog so I could put a 'whenever sqlerror exit' statement in the script, allowing my shell script to trap when my SQL scripts get errors, including invalid user and password. But I get inconsistent results.
Thanks,
Brian
-- Brian M. Biggs mailto:bbiggs_at_cincom.com Cincom Systems, Inc. voice: (513) 677-7661 http://www.cincom.com/Received on Fri Sep 20 1996 - 00:00:00 CEST