Date:         Thu, 21 Nov 2002 22:55:26 -0400
Reply-To:     Shane Hornibrook <shornibr@IS.DAL.CA>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Shane Hornibrook <shornibr@IS.DAL.CA>
Subject:      Re: Is there a way to hide the userid & password in PROC SQL scri
              pt?
Comments: To: Ed Heaton <EdHeaton@westat.com>
In-Reply-To:  <08B08C9FA5EBD311A2CC009027D5BF8104612B6A@remailnt2-re01.westat.com>
Content-Type: TEXT/PLAIN; charset=US-ASCII

On Thu, 21 Nov 2002, Ed Heaton wrote:

> I know of no method to insure security.
> The best we can hope for is to ward off those who are inexperienced
> or who don't have the time to hack the system.

Ed,

Very true! I think the best quick solution the original poster can hope
for is to use your macro code with nomprint, nomlogic, nosymbolgen,
nosource, nosource2, ???. Although it would be nasty to debug, if a
problem arose.

Perhaps also embedding a proc printto into a secure write-only directory?

Caveat Emptor: I have been working on OpenVMS, therefore my security
concerns are reaching an acute level. :) There are many good options for
increasing the security, but as you say, none are impermeable.

--Shane
Shane Hornibrook
GIS Analyst
Web: http://www.geologist.net
Mobile: 902.441.4158