SSMA: Migrating from Oracle to Azure SQL - what are permissions/roles required on Azure SQL side???

%3CLINGO-SUB%20id%3D%22lingo-sub-1003841%22%20slang%3D%22en-US%22%3ESSMA%3A%20Migrating%20from%20Oracle%20to%20Azure%20SQL%20-%20what%20are%20permissions%2Froles%20required%20on%20Azure%20SQL%20side%3F%3F%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1003841%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20using%20SSMA%20-%20SQL%20Server%20Migration%20Assistant%20for%20Oracle%3C%2FP%3E%3CP%3EMigrating%20from%20Oracle%20to%20Azure%20SQL%20-%20what%20are%20permissions%2Froles%20required%20on%20Azure%20SQL%20side%3F%3F%3F%3CBR%20%2F%3EIs%20there%20a%20document%20with%20the%20list%20of%20permissions%20or%20roles%20required%20on%20Azure%20SQL%20side%3F%3F%3F%20Create%20table%2C%20create%20index%2C%20etc%3F%3F%3F%3CBR%20%2F%3EI'm%20using%20SQL%20Server%20authentication%2C%20does%20the%20principal%20need%20sysadmin%20role%3F%3F%3F%3C%2FP%3E%3CP%3EI've%20seen%20documentation%20on%20permissions%20required%20on%20the%20Oracle%20side%2C%20but%20found%20nothing%20for%20the%20Azure%20side%3F%3F%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I'm using SSMA - SQL Server Migration Assistant for Oracle

Migrating from Oracle to Azure SQL - what are permissions/roles required on Azure SQL side???
Is there a document with the list of permissions or roles required on Azure SQL side??? Create table, create index, etc???
I'm using SQL Server authentication, does the principal need sysadmin role???

I've seen documentation on permissions required on the Oracle side, but found nothing for the Azure side???

 

0 Replies