Re: Hide Process?

Chien-Yuan

You don't say if this is version 7 or 6 database, so here's the scoop for each:

For v6: Setup the oracle id as an ops$ id. Say the unix id is cyuan...set the oracle id to ops$cyuan. This will allow you to use the command : 'sqlplus /'. Also be sure to set your password to something different from the id.

For v7. The same this as you do for v6 except now you can specify the prefix (the ops$) in the init.ora file that will denote you are using op system security for an id. You will also need to enable op system security in the init.ora.

Another way that I have found to do this without using the op system security in unix within scripts is like this

   sqlplus <<EOF                        -- The EOF can be any tag..just

   userid
   password
   script name or sqlcommand
   exit
EOF This will result in a process show as just running the script these commands are contained in. Nosqlplus and no password/id shown. Just make sure you set the permissions on the script so that only you can read it.

Hope this is helpful .

Jack Richter Received on Sun Apr 23 1995 - 00:00:00 CEST