Issue is from OEM data masking .Database using account pdbadmin , which has sysdba grant .
But during Application data modeling job below error is coming.
Processing application: TEST_MASK(TEST_MASK)
User does not have sufficient privileges to complete this action, please check the error logs for more information.
java.sql.SQLException: ORA-06598: insufficient INHERIT PRIVILEGES privilege
ORA-06512: at "DBSNMP.MGMT_DDRM_GENERIC_DRV", line 1
ORA-06512: at line 1
CHANGES
None
CAUSE
issue due to insufficient privileges to DBSNMP user.
SOLUTION
grant the missing privileges to DBSNMP user :
GRANT INHERIT PRIVILEGES ON USER SYS TO DBSNMP; ----
GRANT EXECUTE ON DBMS_SQL TO DBSNMP.; ------
ALTER PACKAGE DBSNMP.MGMT_DDRM_GENERIC_DRV COMPILE BODY;
For pdbs you need to mention container=all
ex:GRANT INHERIT PRIVILEGES ON USER SYS TO DBSNMP container=all;