topic Re: Password encryption in SAS Enterprise Guide

Password encryption

srisai — Wed, 01 Dec 2010 16:09:37 GMT

Hi,

Could you please let me know what is the best way to hide user id and password in our code and log though we have macros mlogic,merror,symbolgen are written in our code?

Please advice.

Regards,
Sri

Re: Password encryption

RSB — Wed, 01 Dec 2010 17:28:12 GMT

Hi Sri,

You may use proc pwencode to encrypt the passwords in your code.

This paper gives information on its usage.
http://www.lexjansen.com/pnwsug/2007/Dave%20Steven%20-%20Keep%20your%20database%20passwords%20out%20of%20the%20clear.pdf

SAS Documenation :
http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a002595988.htm

Re: Password encryption

srisai — Wed, 01 Dec 2010 19:07:24 GMT

Hi,

Very informative and here my another doubt is if multiple users wanted to
run the my code with their id and passcode then how to proceed on this?

Thanks,
Sri

Re: Password encryption

ChrisHemedinger — Wed, 01 Dec 2010 22:00:40 GMT

Here's a topic that might help:

http://blogs.sas.com/sasdummy/index.php?/archives/222-Five-strategies-to-eliminate-passwords-from-your-SAS-programs.html

Chris