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!