Date: Thu, 12 Mar 1998 09:40:41 -0600
Reply-To: "Beakley,Steve" <SBEAKLEY@CERNER.COM>
Sender: "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From: "Beakley,Steve" <SBEAKLEY@CERNER.COM>
Subject: Re: Hiding Passwords in SAS/Access Code
The password will automatically be concealed in any log references,
replaced with a series of X's. To conceal the information in the code,
I'd probably recommend compiling the code using the Stored Program
Facility. Another option, a little more complicated but more robust,
would be to pass the password from the operating system using SYSPARM.
I know this is possible on the VMS/Alpha platform, and assume it would
work on other OS's as well.
2800 Rockcreek Parkway, MD 3212
Kansas City, MO 64117
> -----Original Message-----
> From: Deborah Testa [SMTP:firstname.lastname@example.org]
> Posted At: Thursday, March 12, 1998 8:32 AM
> Posted To: comp.soft-sys.sas
> Conversation: Hiding Passwords in SAS/Access Code
> Subject: Hiding Passwords in SAS/Access Code
> We write views to database tables using SAS/Access to Oracle and
> to SQL Server. Both required giving user id's and passwords, which
> are then
> visible in the SAS code. Does anyone have experience concealing these
> values, both in the code and in the SAS log?
> I would appreciate hearing about solutions to this problem.