09-01-2011
Currently is is only aix command line. Here's some detail:
less qry1.sql
db2 -f pswd
db2 -x "select ...............from............" > extract.out
less pswd
connect to db test user userid using password
-----------------------------------------------------------------------
I want to protect unauthorized aix cmd line users from viewing the pswd file, but need it to be "usable" by the qry.sql script.
Should I just chown for all the sql scripts so the users can't look at them, or is there a way to allow them rwx on their sql scripts, but not the pswd file?
BTW, thanks for your response.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi
I want both standard output and standard error of my command cmd to go to the same file log.txt. please let me know the best commandline to do this.
Thanks (2 Replies)
Discussion started by: 0ktalmagik
2 Replies
2. Programming
Hello all
Im using CC: Sun C++ 5.6 2004/07/15 and using the -library=stlport4 when linkning im getting
The fallowing error :
Undefined first referenced
symbol in file
std::ostream &std::ostream::operator<<(std::ios_base&(*)(std::ios_base&))... (0 Replies)
Discussion started by: umen
0 Replies
3. Shell Programming and Scripting
Hi All,
I'm trying to read from two files at the same time, but the second READ is failing, giving no value.
Obvious STDIN is being used by the first "while read", so how can I retrieve a value from a second file within the loop ??
IFS=" ,"
cat $DATAFILE | while read curdate currentcksum... (3 Replies)
Discussion started by: adrianmarsh
3 Replies
4. Shell Programming and Scripting
All,
I am trying to figure out a script to run in windows that will allow me to match on First column in file1 to 8th Column in File2 then
Insert file1 column2 to file2 column4 then create a new file.
File1:
12345 Sam
12346 Bob
12347 Bill
File2:... (1 Reply)
Discussion started by: darkoth
1 Replies
5. Shell Programming and Scripting
Hi All,
Does anyone know how to read multiple lines from standard input into an array and then iterate a loop for all the lines read. Below is an example pseudocode:
I need the below filenames to be read by the script into an array or something similar:
And then in the script, I... (9 Replies)
Discussion started by: bharath.gct
9 Replies
6. Shell Programming and Scripting
Hey guys,
This is my situation.
I'm using the script to add a user account, however, i want the same details copied into the htdigest password list. the format is username:virtualservername:hashed/encrypted password.
This is the command :
sudo htdigest /etc/apache2/passwords... (0 Replies)
Discussion started by: xxxx
0 Replies
7. Shell Programming and Scripting
Hello,
I'm trying to figure out how best to approach this script, and I have very little experience, so I could use all the help I can get. :wall:
I regularly need to delete files from many directories.
A file with the same name may exist any number of times in different subdirectories.... (3 Replies)
Discussion started by: *ShadowCat*
3 Replies
8. Shell Programming and Scripting
hy,
I wrote a simple shell script to monitor (with Nagios) a SNX VPN function. Here the Code snippet:
testing=`ssh user@IP-address 'ls /etc/sysconfig/network-scripts/ifcfg-eth0'`
#echo $testing
if ; then
echo "VPN is working"
exit 0
else snx -s server -u user
... (2 Replies)
Discussion started by: tomies
2 Replies
9. Shell Programming and Scripting
I am looking for a way to start a script and have it prompt for a password that will be used later on in the script to SSH to another host and to SFTP. I don't want the password to be hard coded. Below is my script with the actual IP's and usernames removed.
#!/usr/bin/expect -f... (2 Replies)
Discussion started by: jbrass
2 Replies
10. Shell Programming and Scripting
Hello
Sorry for the question..
i would like to make a script for OS X that allow me to change the password for a user account.
i have to use this script on several iMac with the same user/password.
i want to store the passwords inside the script, no security problems involved.
the... (9 Replies)
Discussion started by: araan87
9 Replies
LEARN ABOUT DEBIAN
cvm-sql
cvm-sql(7) Miscellaneous Information Manual cvm-sql(7)
NAME
cvm-sql - CVM SQL Framework
QUERY SUBSTITUTION
$VAR and ${VAR} are replaced with the quoted value of the environment variable named VAR. Use the second form when VAR contains anything
other than alpha-numeric or underscore (_) characters. Do not include quotes in the query. The variables account and domain contain the
account and domain names given by the CVM client. $$ is replaced with a single dollar sign.
QUERY RESULTS
The query must produce the following fields exactly in order. All required fields must not be null or empty.
1. Password, encrypted with crypt(3) (required)
2. Actual account name (required)
3. User ID (integer) (required)
4. Group ID (integer) (required)
5. Directory (required)
6. Real name (optional)
7. Login shell (optional)
8. Group name (optional)
9. Domain name (optional)
10. System account name (optional)
11. System account directory (optional)
12. Mailbox path (optional)
DEFAULT QUERY
SELECT password, username, userid, groupid, directory, realname, shell, groupname, domain, sys_username, sys_directory FROM accounts WHERE
username=$account AND domain=$domain
SEE ALSO
cvm-mysql(8), cvm-pgsql(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/cvm/cvm.html
cvm-sql(7)