How to decrypt password which is encrypted using proc pwencode.

[jakarman]

Andreas, That document I have linked to is an excellent compass for all laws and regulations(D). Most of those are international similar.

It is mentioning: Cobit, ITIL, IDW PS 330 (D prufing oder English auditing) and  Kontrag(D) BaseslII SOX Euro-SOX BDSG(D dataprivacy)  and cryptography (PKI). There is nice table for type of the company and the relevant standards (page 11-12).

It is ashtonishing IT suppliers exists that are not aware of this and offering solutions that are unnecessary conflicting with them.   

[Venkat4]

Try Proc pwdecode

[SASKiwi]

ERROR: Procedure PWDECODE not found.

[jakarman]

SAS PWDECODE - SAS PWENCODE DECODE    Looks a rainbow approach.
Still te question what SAS has implemented as decode routine to pass that decrypted  to Oracle. With a trace it should be able to catch those at that level between SAS and the external client. 

[RonAgresta · Accepted solution]

The PWENCODE procedure enables you to encode passwords. Encoding obfuscates the data. Unlike encryption, encoding is a reversible permutation of the data and uses no keys.

Encoded passwords can be used in place of plaintext passwords in SAS programs that access relational database management systems (RDBMSs) and various servers. Examples are SAS/CONNECT servers, SAS/SHARE servers, SAS Integrated Object Model (IOM) servers, SAS Metadata Servers, and more.

More on encoding and encryption can be found in the Encryption in SAS documentation.

Ron 

[LB]

While a bypass was looked at as to avoid using a credential file on the linux home folders for SAMBA-

In the end I just created an an autocall macro that a user has to enter in credentials one time only that ports over to the other servers as well. 

The SAS PWDECODE is handy but I also don't want to actually risk sending out passwords to a website.  

Lawrence