Error: The Delete Permission Was Denied on the Object

Issue

All connectors in the destination fail with the following error:

java.util.concurrent.ExecutionException: java.lang.RuntimeException:
java.lang.RuntimeException: java.lang.RuntimeException:
com.fivetran.utils.exceptions.UncheckedSQLException:
com.microsoft.sqlserver.jdbc.SQLServerException: 
The DELETE permission was denied on the object.

Environment

Destination: SQL Server

Resolution

To resolve this issue, do the following:

1. Ensure you have the necessary permissions for the schema you are trying to load data into. You can check this by using the following command: GRANT SELECT, INSERT, UPDATE, DELETE, ALTER ON SCHEMA::<schema_name> TO fivetran;
2. If the owner of the schema has changed, use the following command to make Fivetran the schema owner:
   ALTER AUTHORIZATION ON SCHEMA::<schema_name> TO fivetran;

Cause

This error occurs if you don't have the necessary permissions to write data to your destination or the owner of the schema has changed.