Encoding User Name using PWENCODE?

arunrami — Wed, 19 Dec 2018 15:17:14 GMT

Hello Guys,

I just needed to encrypt or encode user name and password to use it in SAS code instead of using naked user and password . For password , its working fine after using encoded by PROC PWENCODE but it's not the case for User name and I am getting following error message.. Is there any way to hide the user name other than using permanent macro ?

ERROR: ORACLE connection error: ORA-010: invalid username/password; logon denied.
ERROR: Error in the LIBNAME statement.

Re: Encoding User Name using PWENCODE?

Gaetan — Wed, 19 Dec 2018 15:35:13 GMT

Hi @arunrami,

Using AUTHDOMAIN option is the best way :

For example : Usage Note 38204: Using the AUTHDOMAIN= option with SAS/ACCESS® 9.2 engines

Best regards,

Gaetan

topic Encoding User Name using PWENCODE? in SAS Programming

Encoding User Name using PWENCODE?

Re: Encoding User Name using PWENCODE?