ORA-06598: insufficient INHERIT PRIVILEGES privilege (Doc ID 2690051.1)

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;