By
default, SAS Data Integration Studio looks up user credentials rather
than explicitly including them in the code that it generates when
it accesses tables in a library. This behavior can be changed by selecting
ToolsOptions from the main menu, clicking the
General tab,
and then selecting or deselecting the
Use runtime lookup
for credentials for statements requiring credentials check
box. When this option is selected, the code generated by SAS Data
Integration Studio does not contain user names and passwords for SAS
Connect sign-on statements. Instead, the user name and password are
looked up at run time, using the Authentication Domain that has been
specified for the user is his or her metadata identify on the SAS
Metadata Server.
If this option is not
selected, the code that is generated is based on the credentials and
permission settings of the user who generated the code. When required,
such as in LIBNAME statements to a relational DBMS, for pass-through,
or for remote machine data movement, the generated code might also
contain embedded credentials, with encoded passwords.
If the credentials of
the person who created the job are changed and a deployed job contains
outdated user credentials, then the deployed job fails to execute.
The solution is to redeploy the job with the appropriate credentials.