Comments
Sort by recent activity
To confirm: Yes, in Azure SQL Database, the EXECUTE AS CALLER default means the caller needs direct permissions on underlying objects, unlike SQL Server's often-used EXECUTE AS OWNER. You are not missing something; this is a key security difference. Consider modifying the procedure's security context or granting the needed SELECT permission. / comments
To confirm: Yes, in Azure SQL Database, the EXECUTE AS CALLER default means the caller needs direct permissions on underlying objects, unlike SQL Server's often-used EXECUTE AS OWNER. You are not m...