Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to hide sqlplus login/passwd

Re: How to hide sqlplus login/passwd

From: Allan Carr <carrx_at_ibm.net>
Date: Tue, 5 Jan 1999 20:02:39 -0600
Message-ID: <3692c412.0@news1.ibm.net>


>How can I hide username/password when I just want to enter sqlplus
>and run commands from the sql> prompt?

you can also create a login.sql file and put it somewhere in the oracle path. in there you go:
define mypass=whatever
 myuserid=whatever
connect &&myuserid/&&mypass.
then when you go sqlplus / from the command line it will connect as you always.
just make sure nobody else can read the login.sql file. Received on Tue Jan 05 1999 - 20:02:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US