When running the URT it fails with ORA-39087: directory name DATA_PUMP_DIR is invalid

Products

• Data Loss Prevention Enterprise Suite

Issue/Introduction

When running the URT it fails with

 

ORA-39087: directory name DATA_PUMP_DIR is invalid 

Environment

Release : 15.8

Component : Default-Sym

Resolution

This can happen if the URT user is missing permissions OR if the regular DLP protect user is missing permissions.  Run the following two commands as Sys and make sure that both Protect user and the URT user have "READ" and "WRITE" for "DATA_PUMP_DIR"

 

set pagesize 100

SELECT privilege
FROM   dba_sys_privs
WHERE  grantee = 'USER'
ORDER  by privilege;

SELECT privilege, table_name
FROM   dba_tab_privs
WHERE  grantee = 'USER'
ORDER  by privilege, table_name; 

 

Additional Information

See the below article for more information

https://knowledge.broadcom.com/external/article/160062/verify-the-protect-database-user-has-the.html