Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using DBA -> Data Pump without DBA privileges

NarendraPJan 3 2023

SQL Developer Version => 20.4.0.379
When I try to use the DBA -> Data Pump -> Export Jobs -> Data Pump Export Wizard or DBA -> Data Pump -> Import Jobs -> Data Pump Import Wizard, it prevents the wizard with error message "DBA or PDB_DBA privilege required".
We have stringent security controls in place which means I can have neither of those roles assigned to my user. Is there any way, I can still use these wizards without those DBA roles?
I really like the idea of being able to generate PL/SQL code that uses DBMS_DATAPUMP API with the help of the UI wizard but can't seem to get it working.
Thanks in advance

Comments
Post Details
Added on Jan 3 2023
3 comments
2,194 views