I'm seeking a solution to saving third-party database credentials in my SAS scripts. Specifically, I need to find a way for SAS scripts that connect to Oracle database servers don't need to contain a user's database password. These scripts are frequently run on a schedule using crontab in our environment, in addition to being run manually by end users. I'm familiar with using AUTHDOMAINs in my scripts to avoid using database passwords in the script. For a script that I can run successfully in SAS Studio or SAS EG, I find that it fails when I launch it using crontab. I see the following message in my program's log: 6 PROC SQL; 7 CONNECT TO oracle (user=&my_sso. AUTHDOMAIN="DatabaseAuth" path="Database"); NOTE: Credential could not be obtained from SAS metadata server. WARNING: No login information was available for authdomain DatabaseAuth. ERROR: ORACLE connection error: ORA-12162: TNS:net service name is incorrectly specified. Any suggestions? It doesn't seem possible that SAS has not provided a solution for encrypting (NOT ENCODING LIKE PROC PWENCODE) passwords that is also compatible with the command-line interface.
... View more