Dear All,
I have a plsql procedure used to create a dump files on DB.
This procedure is working fine when executed with a user with DBA privilege.
I need to be able to execute the same procedure with a user without DBA privilege.
I removed it and , as by oracle documentation https://docs.oracle.com/en/database/oracle/oracle-database/12.2/arpls/DBMS_DATAPUMP.html#GUID-AEA7ED80-DB4A-4A70-B199-59…
I assigned the user the DATAPUMP_EXP_FULL_DATABASE and DATAPUMP_IMP_FULL_DATABASE privileges.
I am now getting ora-31631: privileges are required when I execute the command below:
DBMS_DATAPUMP.metadata_filter (handle => h1, NAME => 'SCHEMA_EXPR',
VALUE => v_schema_expr);
I have the bad filling that is mandatory to use the DATAPUMP package with DBA privilege.
Can same one help me?
Regards Pierp