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.
 
 
Steven Beakley
CERNER CORPORATION
2800 Rockcreek Parkway, MD 3212
Kansas City, MO  64117
(816) 201-1403
sbeakley@cerner.com
 http://www.cerner.com
 
 
 
> -----Original Message-----
> From: Deborah Testa [SMTP:dtesta@delphi.com]
> 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
> SAS/Access
> 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.
>