I want to set up Lakeflow Connect to ETL data from Azure SQL Server (Microsoft SQL Azure (RTM) - 12.0.2000.8 Feb 9 2025) using change tracking (we don't need the data retention of CDC). In the documentation, there is a list off system tables, views and sprocs we need to grant the ETL user access to (https://learn.microsoft.com/en-us/azure/databricks/ingestion/lakeflow-connect/sql-server/database-us...).
When I try to update permissions on the system objects, I get the following error
Msg 40574, Level 16, State 1, Line 1
Permissions for system stored procedures, server scoped catalog views, and extended stored procedures cannot be changed in this version of SQL Server.
Is this a known issue, and if so, is there a known way to work around trying to change permissions on system objects?
