Secure access to oracle Data Base with proc scaproc

Pavlo11 — Wed, 26 May 2021 13:39:50 GMT

Dear all,

I am trying to connect to database using libname statement. I call this statement from secure macro. So I don't save password in code. My question is, can I mask password is the output of proc scaproc? Because we have all the credentials outputed there

proc scaproc; 
      record "Result.txt"; 
run;

 proc scaproc; 
       write; 
run;

libname DataBase oracle user="XXX" password="XXX" path="XXX";

Re: Secure access to oracle Data Base with proc scaproc

CarmineVerrell — Wed, 26 May 2021 13:50:07 GMT

No, proc scaproc won't mask your credentials.

Here is a paper that i found that might help.

013-2009: Secret Sequel: Keeping Your Password Away from the LOG (sas.com)

topic Re: Secure access to oracle Data Base with proc scaproc in Developers

Secure access to oracle Data Base with proc scaproc

Re: Secure access to oracle Data Base with proc scaproc