As a Production SQL DBA, checking user permissions is a task I handle frequently. Whether it’s for proactive audits, troubleshooting access issues, or responding to unexpected requests, having a quick and reliable way to verify user permissions is needed.
One of the most useful tools I rely on for this task is a SQL script that provides a comprehensive view of user roles, permissions, and group memberships. It’s especially helpful for identifying permissions inherited from Active Directory (AD) groups, which can sometimes be tricky to track manually.
SQL Script to Check User Permissions
This SQL script audits user permissions across all databases, listing roles, SQL users, and Windows groups:
Leave a Reply