There are a number of common techniques, but the one I prefer is to:
1) create a text file with a set of usernames/passwords - one per line
(e.g one line might be "sys change_on_install")
2) Put the script somewhere secure and make it a hidden file (e.g.
.userpass) Also, chmod it so only th
Here's how to do it from a UNIX script for SQL*Plus:
sqlplus -s /nolog<
@calanais.comcc:
>Subject: RE: Concealing SQL
Loader password
Sent by: rootfrom ps -ef
10/26/
Simplest way is not to enter the password on the same line with the userid.
If you wait for SQLPlus to prompt you for the password, it doesn't show up
with ps -ef.
On the other hand, doing this in a script is more problematical. Anyone
have any examples?
Rather simple. Use an OPS$ account.
Arno
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Disser, Arno
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
-
Jay,
Could you tell me how to do this for SQL*PLUS, I'm too lazy to look now that
I've found someone that knows ;o)
Cheers,
Kev.
"hit any user to continue"
__
Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
(2nd Floor East - Weirs Building)
Tel: 0141 568 2377
Title: RE: Concealing SQL Loader password from ps -ef
You could also use a parameter file... Look at the utilities manual under the command line reference... The example from Oracle is...
PARFILE specifies the name of a file that contains commonly used command-line parameters. For example
The << operator creates a set of commands to be executed until a particular
label as part of the calling command and only the calling command is
displayed on ps -ef. This should work the same for sqlloader as it does for
sqlplus or ftp or su or whatever else. Just put the username/password on
th
When running Sql Loader from a Unix script is there a way to code it so that
the password will not be displayed when someone does ps -ef?
I know how to do it for sqlplus, exp and imp but not sql loader.
TIA,
Jay Miller
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: M