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.
Try Proc pwdecode
ERROR: Procedure PWDECODE not found.
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.
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
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.