search

Esri / developer-support

Proof of concept developer code and samples to help be successful with all ArcGIS developer products (Python, NET, JavaScript, Android…). The repository is designed to be an exchange for sharing coding conventions and wisdom to developers at all skill levels.
Apache License 2.0
266 stars 164 forks source link

IMPDP.sql - additional information #376

Open danikane opened 2 years ago

danikane commented 2 years ago

Hi, this is related to the IMPDP procedures listed here: https://github.com/Esri/developer-support/blob/master/arcsde-sql/oracle/data-pump/IMPDP.sql

I experience the behavior described here: https://support.esri.com/en/technical-article/000012391

For me the solution was to make an additional: GRANT INHERIT ANY PRIVILEGES TO "SDE"; as well as grant EXECUTE ON dbms_crypto to public;

I hope that helps someone. Thanks you for the script, saved a lot of work!