Re: SQLPlus scripts in Unix

From: Steven Hauser <hause011_at_garnet.tc.umn.edu>
Date: 8 Jun 1999 11:45:29 -0500
Message-ID: <7jjhb9$5pj$1@garnet.tc.umn.edu>

If the question was how to secure the sqlplus name/password in a Unix shell script.

Write the name/passwd on the next line in a "here" document then the "ps" command will not show the name and password as it does when it is on the command line. Make sure the script does not have permissions for everyone to read it. You are then minimally secure.

Example:
sqlplus << EOF
name/passwd

    set pages 0 feed off echo off
    select field_y from table_x;
EOF --

---

Steven Hauser
email: hause011@tc.umn.edu URL: http://www.tc.umn.edu/~hause011

---

Received on Tue Jun 08 1999 - 11:45:29 CDT