Hello,
How can we set it up so that developers do not have to hard code logon and passwords in scripts. We bounce between Dev, UA, and Prod using Oracle and SQL Server.
Thank you,
Goo
CM V.6.4.01
Oracle
SQL server
Hide/Encrypt DB Passwords in Scripts
We do this:
1. in the script switch off the echo of the command so the passwords was not reported on the sysout:
@echo off on batch scripts
set +x on on shell scripts
2. put parameters on the scripts substituting user and passwords entry.
something like:
batch
SET USR=%1
SET PWD=%2
shell
Usr=$1
Pwd=$2
3. Put user and pwd in the set panel of the job USING THE LIBMEMSYM manner.
4. the file and directory in witch is saved the LIBMEMSYM that conten password are protected from users access.
I Advice also to use for the path of the LIBMEMSYM file to use a global variable so:
- is not see in the job definition the local of the file
- you can change it without redefining all jobs that use them
Have a good day
1. in the script switch off the echo of the command so the passwords was not reported on the sysout:
@echo off on batch scripts
set +x on on shell scripts
2. put parameters on the scripts substituting user and passwords entry.
something like:
batch
SET USR=%1
SET PWD=%2
shell
Usr=$1
Pwd=$2
3. Put user and pwd in the set panel of the job USING THE LIBMEMSYM manner.
4. the file and directory in witch is saved the LIBMEMSYM that conten password are protected from users access.
I Advice also to use for the path of the LIBMEMSYM file to use a global variable so:
- is not see in the job definition the local of the file
- you can change it without redefining all jobs that use them
Have a good day
- philmalmaison
- Nouveau
- Posts: 1148
- Joined: 08 Jun 2007 12:00
- Location: Ile de France