| Suppressing username/password while using sqlldr [message #72577] |
Wed, 23 July 2003 06:33  |
Monika
Messages: 9
Registered: November 2000
|
Junior Member |
|
|
Hi All,
I am using sqlldr inside a shell script, specifying all necessary keywords to it like data,control etc. I also use keyword silent=header.
Now while the shell script is running , if I use the command ps -Af (in UNIX) , it shows the username and password used in sqlldr.
Could anybody please suggest how to suppress this username/password displayed while using ps -Af .
Thanks,
Monika
|
|
|
|
| Re: Suppressing username/password while using sqlldr [message #72585 is a reply to message #72577] |
Thu, 24 July 2003 07:13  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
i beleive, you can use a parameter file.
and use OS facilities to secure the file from other users
[b] quoting the docs [/b]
PARFILE specifies the name of a file that contains commonly used command-line parameters. For example, the command line could read:
sqlldr PARFILE=example.par
The parameter file could have the following contents:
USERID=scott/tiger
CONTROL=example.ctl
ERRORS=9999
LOG=example.log
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
