Activity overview
Latest activity by thomosjr
Great observation, Cathy. Your explanation helps clarify why the behavior differs between environments. When queries are executed through dynamic SQL, permission inheritance may not function as expected. Where which can result in access-related errors even when a stored procedure appears to be configured correctly. I’ve encountered a comparable situation in Azure SQL Database where a procedure that runs without issues on SQL Server generates permission warnings in the cloud environment. Mega Flix APK looks like a useful entertainment <a href="https://themegaflix.pro/"> App </a> with a simple interface and plenty of features. Thanks for sharing this information—it was helpful to read. / comments
Great observation, Cathy. Your explanation helps clarify why the behavior differs between environments. When queries are executed through dynamic SQL, permission inheritance may not function as exp...
Thanks for pointing that out, Cathy. That makes sense. If dynamic SQL is involved, then the normal ownership chaining rules wouldn’t apply, and you’d need explicit permissions on the referenced objects. I’m running into a similar issue on Azure SQL DB where a stored proc works fine on SQL Server but throws a SELECT permission error on Azure. I’ll double-check whether there’s any dynamic SQL in the proc that's causing the break in the chain. Appreciate the insight! The best part about Hdo Box Application is that it’s completely free. It works with different devices, so I can stream on my TV too. The search function makes finding movies and shows super easy / comments
Thanks for pointing that out, Cathy. That makes sense. If dynamic SQL is involved, then the normal ownership chaining rules wouldn’t apply, and you’d need explicit permissions on the referenced obj...