Date:         Thu, 28 Apr 2005 09:35:14 -0400
Reply-To:     "Bosch, Jules" <jules.bosch@SPCORP.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Bosch, Jules" <jules.bosch@SPCORP.COM>
Subject:      Oracle Username and Password

Dear All,

Earlier this week Ravi posted a query regarding Oracle passwords.  My
challenge is somewhat related to Ravi's. What I want to do is mask the
Oracle password from the SAS logs that are produced along with each SAS
report execution.

Currently, the password and username are stored in a separate folder and
read at the start of any SAS/Oracle report execution wherein they become
macro variables. Subsequently, they appear on the SAS log by virtue of the
macro-related OPTIONS (MPRINT, et al) in effect. The best I have come up
with is a macro that simply reads the SAS log, changes the Oracle
password/username to XXXXXXX, and then puts the SAS log back to bed.

The passwords are not displayed in the SAS log if the macro-related OPTIONS
are turned off.  However, we need these OPTIONS to be in effect.

Any suggestions?

TIA,

Jules Bosch



*********************************************************************
This message and any attachments are solely for the intended recipient. If you are not the intended recipient, disclosure, copying, use or distribution of the information included in this message is prohibited -- Please immediately and permanently delete.