Hi all,
Can anyone please advise how I can change the following codes to work where
the <username> and <correct_pass> are not exposed?
Script is ran via crontab and can also be run manually, at the moment am
reading these values from some sort of delimited file.
The worry is someone getting access to the script and then putting in some
print commands to expose the username and password information.
Just thinking in advance before it happen. The original script is a UNIX
script but I thought there may be a Perl module that will masked
the password where there is none of the same thing for UNIX scripts.
#!/usr/bin/perl
use DBI;
......
......
$dbh = DBI->connect('dbi:Oracle:host=localhost;sid=test;port=1521',
'<username>', '<correct_pass>');
my $sth = $dbh->prepare("alter session set nls_date_format = 'DD-MON-YYYY
HH24:MI:SS'");
$sth->execute();
my $sth = $dbh->prepare("select 'Today is ' || sysdate from dual");
$sth->execute();
while (my ($sysdate) = $sth->fetchrow_array()) {
print $sysdate, "\n";
}
$sth->finish();
exit 0;
Any feedback will be very much appreciated. Thanks in advance
