Skip to content

Instantly share code, notes, and snippets.

View Epommier's full-sized avatar
🎯
Focusing

Epommier

🎯
Focusing
View GitHub Profile
We can't make this file beautiful and searchable because it's too large.
address,counts
0x6977e753e022f65ebeb170d8267b2ea54a431523,7
0x549c0421c69be943a2a60e76b19b4a801682cbd3,7
0xee2826453a4fd5afeb7ceffeef3ffa2320081268,6
0x93f5af632ce523286e033f0510e9b3c9710f4489,6
0xc7bfd896cc6a8bf1d09486dd08f590691b20c2ff,6
0x83aba53382af0754e2599312f02dfc6774489f82,6
0x047b3e73043bbf7421b78893110fc30b7db6b126,6
0x87616fa850c87a78f307878f32d808dad8f4d401,6
0x316f99537b4bade5eea51073f1b7c38dfbf69a70,6
@stvnrs
stvnrs / get-role-members.sql
Created May 9, 2017 11:23
List role members in a SQL Server database
SELECT
roles.[name] as role_name,
members.[name] as user_name
FROM sys.database_role_members
JOIN sys.database_principals roles ON database_role_members.role_principal_id = roles.principal_id
JOIN sys.database_principals members ON database_role_members.member_principal_id = members.principal_id
ORDER BY
roles.[name],
members.[name]