Consider the following when deciding were to specify values for security attributes:
- Operators can be more generally applied if they are not required to carry values for the security-related attributes, although these values can be overridden in APPLY statements
- When processing sensitive information with Teradata PT, specifying the UserName and UserPassword values as job variables avoids problems that may occur if such logon information is kept in plain view in job scripts.
- If a single user has the privileges necessary to run an entire job script, specify the UserName and UserPassword values as job variables rather than individually in the operators, other objects, or APPLY statements.
- If privilege requirements vary greatly among instances of the same object, specify the UserName and UserPassword values in the APPLY statement.
Teradata PT jobs log on to either the database, an outside data source, or both. Logon requirements differ between the database and outside data sources.