Part of my job at work is to update Transact-SQL reference content. System dynamic management views (DMVs) have permissions that are managed in the SQL Server Database Engine source code, so it’s a little tricky to figure out the required permissions for a specific DMV. This blog post provides a stored procedure that uses sys.fn_builtin_permissions… Get required permissions for DMVs
The post Get required permissions for DMVs appeared first on Born SQL.