Using the System Variables › Password System Variable

Password System Variable

The password system variable is disabled by default because it has the following potential for abuse:

Instead of defining a UDP that allows the current user to execute a command-line utility, someone could define a UDP to discover CA Harvest SCM passwords. Therefore, use password system variables only at sites where access to define UDPs is limited to trusted users.

SQL scripts let you update a table column in the CA Harvest SCM database to enable the password system variable. The scripts are located in the database directory under CA_SCM_HOME. To run the scripts, use the following syntax:

Oracle:

sqlplus harvest schema owner/password @EnableSysVarPw.sql

SQL Server:

osql -d DBname -i EnableSysVarPw_sqlserver.sql -U owner -P password -e -b -o log_file