Transformation Map for in flight data masking sub setting throwing insufficient privilege error


Article ID: 129549


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


       We are using Transformation map to extract transform, subset and load data into target environment. We are using Oracle source as target schema. While running the export script, getting below error and export has failed.

ERROR at line 1: 
ORA-01432: public synonym to be dropped does not exist. 


ERROR at line 1: 
ORA-01031: insufficient privileges 


Export script has thrown with an error "ORA-01031: insufficient privileges" and "ORA-01432: public synonym to be dropped does not exist. "
       The first time was during a "create or replace directory" call, and the second was during a "DROP SEQUENCE" call. This appears to be a legitimate permissions issue with the account you are using.
        Please have your Oracle DBA verify the account you are using has sufficient privileges and rolls set complete these tasks from a database perspective.


CA TDM 4.7 (Datamaker, GT Subset and Transformation map) 
Source and Target database is: Oracle


After granting DROP privileges to user account and providing read/write access to the directory where dump files are created, we are able to run both import and script scripts.

Additional Information