search

darold / ora2pg

Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.
http://www.ora2pg.com/
GNU General Public License v3.0
978 stars 341 forks source link

[Urgent Question] NON DBA Account to generate report and export #1726

Closed anandsolomon closed 5 months ago

anandsolomon commented 5 months ago

Hi, We don't want to use the schema username or the system or sys account for ora2pg migration effort. We would like to use non-dba account, but having the below privileges to generate the assessment report and connect, create session, resource, select any dictionary, select_catalog_role, select any table and in ora2pg config, we have USER_GRANTS 1. But the report generated, is missing Package, Triggers, Sequence and also size of the DB. Can you please suggest what other grants we will need to do this work ?

darold commented 5 months ago

You should contact your Oracle DBA to know which privileges should be granted to the Ora2Pg Oracle user.