Encoding User Name using PWENCODE?

[arunrami]

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.

[Gaetan]

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