What are required permissions for data migration to SQL MI using SSMA

Question

I'm working on data migration from an on-premise Oracle database to an SQL MI database. I plan to use SSMA for this task.

Anyone can suggest what are permissions that need to be granted to my SQL authen account for SQL MI side ?

Thanks !!

Answer 1

You need admin permissions to create all objects for the migration.

Answer 2

Hi @Soravis Prommas

Here is the list of permissions necessary for SSMA with the explanation as to why each permission is needed: Connecting to Oracle Database (OracleToSQL).

In order to better understand what particular system data dictionary/view is hidden behind what permission in Oracle, you can switch "Collector" logs to "Debug" under Tools -> Global Settings -> Logging in SSMA. Once you attempt to connect to Oracle with the "read-only access" user, you will be able to see in the log file which queries SSMA attempted to execute and whether they have failed due to permissions.

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.