Oracle

Oracle To SQL Migration – Permissions

Objective:

To migrate oracle database objects to SQL Server via SSMA, the following permissions requires from Oracle (Oracle Permissions to Migrate via SSMA)

Reference:

https://docs.microsoft.com/en-us/sql/ssma/oracle/connecting-to-oracle-database-oracletosql

Required Oracle Permissions:

The account that is used to connect to the Oracle database must have at least CONNECT permissions. This enables SSMA to obtain metadata from schemas owned by the connecting user. To obtain metadata for objects in other schemas and then convert objects in those schemas, the account must have the following permissions: +

•CREATE ANY PROCEDURE
•EXECUTE ANY PROCEDURE
•SELECT ANY TABLE
•SELECT ANY SEQUENCE
•CREATE ANY TYPE
•CREATE ANY TRIGGER
•SELECT ANY DICTIONARY

Leave a Reply

Your email address will not be published. Required fields are marked *