Creating TDM Audit Triggers

Document ID : KB000045304
Last Modified Date : 14/02/2018
Show Technical Document Details


When trying to create audit triggers in the Administration Screen, I get the following error that is in a popup window:

The PL/SQL function "get_program ()" required to create the audit triggers is missing or inaccessible to this user. 
Please contact support for a copy of "f_get_program.pls" and run into the Test Data Repository using a privileged Oracle account before creating the triggers.



Test Data Manager (TDM) 3.1.1 to present


Specific permissions must be granted and inserts are made.


1.   Per the error message you need to accomplish these prerequisites:

  1.  Contact support for a copy of "f_get_program.pls" -  try looking in C:\Program Files (x86)\Grid-Tools\GTDatamaker (or the folder that GTDatamaker was installed into in your environment.)  If it is not on your system, please contact Support.
  2. Run into the Test Data Repository using a privileged Oracle account -  i.e. Have your DBA or Manager of the database run f_get_program.pls in a program such as SQLPlus.

                                       i.    These instructions are for sqlplus.  Before you log into sqlplus with an Administrator or DBA account, change directory to the location of the f_get_program.pls by using a command such as
cd C:\Program Files (x86)\Grid-Tools\GTDatamaker

                                     ii.    Now log into the sqlplus program.  This may vary per installation, so please use the appropriate command for your enterprise.

                                    iii.    Run the using the following command:
Depending on your current configuration, you will get an output such as this example output:

DROP FUNCTION system.get_program
ERROR at line 1:
ORA-04043: object GET_PROGRAM does not exist

ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist
Grant succeeded.
Function created.
Grant succeeded.
Synonym created.

Now, back to what you started to do which is Create Audit Triggers

  1.  Launch Datamaker as administrator.
  2.  Log in using the default administrator credentials:
    User name: <<as defined by your organization>>
    Password: <<as defined by your organization>>
  3.   Access the main Datamaker window without connecting to a data source.
  4.  Click Settings, Maintain Schemas (or press Ctrl + Alt + M) to open the Maintain Schemas dialog, and enter your administrator credentials.
  5. Expand Datamaker Connection maintenance, Datamaker Test Data Repository, and choose Create Audit Triggers. 
  6.  Click Execute Script. 

Additional Information:

How to Perform Repository Maintenance