RVR-SYNP-403
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.
Action steps
To resolve the error, follow these 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】.
- Grant the necessary privileges to the user expected to perform operations via Data Integration. You can grant permissions using SQL commands such as:
- 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.
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.
note
If the issue persists or you need further assistance, open a case with Data Integration Support. In the console sidebar, select Help > Contact Us and follow the instructions.
