shell中使用sqlplus及调试相关

五、为了安全要求每次执行shell都手工输入密码
$vi test5.sh #!/bin/bash echo -n "Enter password for u_test:" read PASSWD sqlplus -S /nolog <<EOF conn u_test/$PASSWD
select * from tab;
exit
EOF

$chmod +x test5.sh$ ./test5.sh

六、为了安全从文件读取密码
对密码文件设置权限, 只有用户自己才能读写.

$echo 'iamwangnc' > u_test.txt$ chmod g-rwx,o-rwx u_test.txt
$vi test6.sh #!/bin/bash PASSWD=`cat u_test.txt` sqlplus -S /nolog <<EOF conn u_test/$PASSWD
select * from tab;
exit
EOF

$chmod +x test6.sh$ ./test6.sh

http://blog.sina.com.cn/s/blog_87fad56a0100yjpp.html

http://blog.sina.com.cn/s/blog_8333cf8f0100z7e3.html

http://www.cnblogs.com/softwaretesting/archive/2012/02/06/2339671.html