Skip to content

Instantly share code, notes, and snippets.

@CreativeNotice

CreativeNotice/gist:9db86d0b17b61882e08a

Last active August 29, 2015 14:08
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save CreativeNotice/9db86d0b17b61882e08a to your computer and use it in GitHub Desktop.
Save CreativeNotice/9db86d0b17b61882e08a to your computer and use it in GitHub Desktop.
Download ZIP
MS SQL Get All User Roles for DBs
Raw
gistfile1.sql
sp_MSForEachDB '
USE [?]
SELECT db_name() dbname, dbU.[name] AS [user], dbGp.[name] AS [Group]
FROM sys.database_role_members AS dbRM
JOIN sys.database_principals AS dbU ON dbU.[principal_id] = dbRM.[member_principal_id]
JOIN sys.database_principals AS dbGp ON dbGp.[principal_id] = dbRM.[role_principal_id]
'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment