...
GRANT EXECUTE on dbms_crypto to <YOUR USER NAME>;
GRANT SELECT_CATALOG_ROLE TO <YOUR USER NAME>;
GRANT SELECT ANY DICTIONARY TO <YOUR USER NAME>;
grant READ on sys.dba_transformations to <YOUR USER NAME>;
grant READ on sys.dba_objects to <YOUR USER NAME>;
grant READ on sys.dba_queues to <YOUR USER NAME>;
grant READ on sys.dba_queue_tables to <YOUR USER NAME>;
grant READ on sys.dba_synonyms to <YOUR USER NAME>;
grant READ on sys.dba_indexes to <YOUR USER NAME>;
grant READ on sys.dba_cons_columns to <YOUR USER NAME>;
grant READ on sys.dba_nested_tables to <YOUR USER NAME>;
grant READ on sys.dba_all_tables to <YOUR USER NAME>;
grant READ on sys.dba_tab_privs to <YOUR USER NAME>;
grant READ on sys.dba_scheduler_jobs to <YOUR USER NAME>;
grant READ on sys.dba_scheduler_programs to <YOUR USER NAME>;
grant READ on sys.dba_scheduler_schedules to <YOUR USER NAME>;
grant READ on sys.dba_mview_logs to <YOUR USER NAME>;
grant READ on sys.dba_procedures to <YOUR USER NAME>;
grant READ on sys.dba_aq_agents to <YOUR USER NAME>;
grant READ on sys.dba_queue_publishers to <YOUR USER NAME>;
grant READ on sys.dba_queue_schedules to <YOUR USER NAME>;
grant READ on sys.dba_queue_subscribers to <YOUR USER NAME>;
grant READ on sys.dba_queue_tables to <YOUR USER NAME>;
grant READ on sys.dba_dependencies to <YOUR USER NAME>;
grant READ on sys.dba_sequences to <YOUR USER NAME>;
grant READ on sys.dba_source to <YOUR USER NAME>;
grant READ on sys.dba_triggers to <YOUR USER NAME>;
grant READ on sys.dba_views to <YOUR USER NAME>;
grant READ on sys.dba_roles to <YOUR USER NAME>;
grant READ on sys.dba_users to <YOUR USER NAME>;
FDORA_USER needs Create and alter Permissions for the schemas being synced. Using the schema owner as FDORA_USER may be the easiest solution, and is needed if triggers don’t have schema-qualified table references.
...