RVR-SYNP-403

1. Issue Summary

   • The error "Denied access table grants and permissions. Error Code: RVR-SYNP-403" indicates that the user attempting to connect through Data Integration to Azure Synapse does not have the necessary permissions to access a specific table or schema. This error is commonly associated with insufficient database permissions or not having the correct privileges assigned to the database user.

2. Action Steps:

   • Verify the user's permissions:
     • Grant the necessary privileges to the user expected to perform operations via Data Integration. You can grant permissions using SQL commands such as:

       GRANT CONNECT ON DATABASE `<database>` TO `<username>`;
       GRANT USAGE ON SCHEMA `<schema>` TO `<username>`;
       GRANT SELECT ON ALL TABLES IN SCHEMA `<schema>` TO `<username>`;
     • Ensure that these permissions are granted for the appropriate database and schema needed for your operations【4:2†source】.
   • Check that the user has appropriate permissions within the Azure Synapse instance. This includes ensuring the user has access to necessary tables and that there are no network-level restrictions preventing access.
   • If using Azure Active Directory for authentication, ensure that the AAD user or role is correctly configured and has the necessary permissions within the Azure Synapse environment.

3. External References:

   • For further reading on granting permissions in Azure Synapse, please refer to the Azure Synapse documentation regarding managing logins and users.
   • Detailed connection and permission configuration can be found in the Data Integration Azure Synapse documentation.

If the issue persists or you need further assistance, please open a ticket with Data Integration support.