We help IT Professionals succeed at work.

Protect password

sonmic
sonmic asked
on
Hi,

I use the following instruction in SAS :
LIBNAME  accdb access &accdb2 DBPASSWORD = "nnn9999" ;
When someone executes the SAS he can also see the password of the access database.
Is there a way to avoid this?

Tx
Comment
Watch Question

Hi

I don't have access to SAS right now to check, but I remember there was a PROC PWENCODE that encoded the password so the actual password was not stored in the code. You will have to check out the PROC in SAS help...
CERTIFIED EXPERT
Commented:
proc pwencode in="nnn9999"; run;

you can add the method option to use a stronger encryption by default, it's sas001, using sas002 will use a higher level of encrpytion: method=sas002

Explore More ContentExplore courses, solutions, and other research materials related to this topic.