When on UNIX server we connect to database and set spool on and invoke connection.sql .. in the output spooled file we see the password. We want the password to be in encrypted form .. how can we achieve that?
Code:
SQL> set echo on
SQL> set feed on
SQL> set termout on
SQL> set sqlblanklines on
SQL> @GTBIR_DW/dbscripts/connection.sql BIR
SQL> def ora_user =&1
SQL>
SQL> CONNECT A_PROXY[&ora_user]/abc123@DEV01
Connected.
SQL> spool off
In the spooled file we want something like this instead of displaying the password.
Is there any better way of doing this? I only want to find a status of a diff, ie diff the file and return to me whether it is different or not or non-existant.
This example works, however I think it could be less messier:
workd=`pwd`;find $workd -name "*.sum" | while read line ; do... (1 Reply)
Hi!
Can someone explain me exactly this technique? Why a process (PARENT) creates a copy of itself with FORK (CHILD)? What's the reason of this behaviour? Sorry, but I cannot understand the logic behind it.
Thanks. (4 Replies)
hello,
I have lots of mail clients, with private IPs, sending mail through our mail server. In the header of each mail outgoing I can find something like
Received: from ()
by linux-virtua1.localhost (8.13.8/8.13.8/SuSE Linux 0.8)
...
question is: is there any way to avoid the private... (2 Replies)
I have a snippet file with the shown below:
data file
1 2
1 3
1 3
4 2
3 2
2 1
2 2
5 1
3 2
3 2
2 3
1 4
Actual file has approx 50 Millions such lines with bigger number (9 Replies)
Hi
We send *.csv with sensitive data to our customers. Our customers open those files with Excel.
A new requirement is that we password protect those CSV files.
I thought to pack them with ZIP and assign a password to the archive.
But Solaris 10 can't encrypt ZIP files.
$ zip -P... (12 Replies)
It seems that the Francisco Rosales home page has gone off-line.
Is there another source for this? I have found it very useful, but others may also find good use for it - and of course, in turbulent times, I may find myself in a new job too, where I'd like to use it again I'm sure.
... (5 Replies)
Hi all,
I am working on a sample backup code, where i read the files per 7200 bytes and send it to server. Before sending to server, i compress each 7200 bytes using zlib compression algorithm using dictionary max length of 1.5 MB . I find zlib is slow.
Can anyone recommend me a... (3 Replies)
Discussion started by: selvarajvss
3 Replies
8. Forum Support Area for Unregistered Users & Account Problems
I was unable to login and so used the "Forgotten Password' process. I was sent a NEWLY-PROVIDED password and a link through which my password could be changed. The NEWLY-PROVIDED password allowed me to login.
Following the provided link I attempted to update my password to one of my own... (1 Reply)
Discussion started by: Rich Marton
1 Replies
LEARN ABOUT DEBIAN
cvm-pgsql
cvm-pgsql(8) System Manager's Manual cvm-pgsql(8)NAME
cvm-pgsql - PgSQL module
SYNOPSIS
cvm-pgsql
CREDENTIALS
Pass phrase
DESCRIPTION
This module queries a PgSQL database for the account name, compares the stored pass phrase with the given one using crypt(3).
CONFIGURATION VARIABLES
The server hostname, port, database, username, password, and additional options can be controlled by setting $PGHOST, $PGPORT, $PGDATABASE,
$PGUSER, $PGPASSWORD, and $PGOPTIONS respectively, which are parsed by the PgSQL client library.
CVM_MYSQL_POSTQ (optional)
The SQL query to execute after the credentials have been validated, see cvm-sql(7).
CVM_PGSQL_PWCMP (optional)
The password comparison module to use.
CVM_PGSQL_QUERY (optional)
The SQL query to issue to retrieve the row containing the account information from the database.
SEE ALSO cvm-sql(7), cvm-mysql(8), cvm-pwfile(8), cvm-qmail(8), cvm-unix(8), cvm-vmailmgr(8), cvm-benchclient(8), cvm-checkpassword(8), cvm-test-
client(8)
http://untroubled.org/pwcmp/pwcmp.html
http://untroubled.org/cvm/cvm.html
cvm-pgsql(8)