Activity overview
Latest activity by jake mical
Yes, permissions do work a bit differently in Azure SQL compared to on-prem SQL Server. In Azure, ownership chaining and execution context can behave more strictly, which is why you might see a SELECT permission error even though the same proc works fine locally. Often the fix is to ensure the stored procedure owner matches the table owner, or explicitly grant SELECT where needed. It’s not unusual to hit this difference when moving from SQL Server to Azure DB. / comments
Yes, permissions do work a bit differently in Azure SQL compared to on-prem SQL Server. In Azure, ownership chaining and execution context can behave more strictly, which is why you might see a SEL...