Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: system passwd viewable via ps -ef

Re: system passwd viewable via ps -ef

From: MarkP28665 <markp28665_at_aol.com>
Date: 1997/04/09
Message-ID: <19970409213600.RAA02480@ladder01.news.aol.com>#1/1

There are several work arounds to this problem.

  1. Get the UNIX System Admin to cover ps with a shell script that looks for and covers passwords
  2. If you are executing sqlplus interactively, let if prompt you for the password
  3. Use OS authorization,i.e., no password required if Os user running script has been set up in Oracle
  4. Have the batch script signon to Oracle using an unsecured id, and within the script being ran using the '@' do a connect to the object authorized id: sqlplus anyuser/anyuser @the_batch_script

and inside the script:
  connect secured_id/password
  sql
  exit

Hope this helps.
Mark Powell -- The only advise that counts is the advise that you follow so follow your own advise Received on Wed Apr 09 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US