Timeline for How do I identify all super users in SQL Server?
Current License: CC BY-SA 3.0
15 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 16, 2022 at 16:02 | comment | added | Tarzan | SELECT DP1.type ,DP1.name AS DatabaseRoleName ,isnull (DP2.name, 'No members') AS DatabaseUserName FROM sys.database_role_members AS DRM RIGHT OUTER JOIN sys.database_principals AS DP1 ON DRM.role_principal_id = DP1.principal_id LEFT OUTER JOIN sys.database_principals AS DP2 ON DRM.member_principal_id = DP2.principal_id WHERE DP1.type = 'R' --AND DP1.name = 'db_owner' ORDER BY 1,2; | |
| Jan 22, 2019 at 22:32 | answer | added | Kin Shah | timeline score: 0 | |
| Jan 22, 2019 at 22:24 | answer | added | Ali Ben Tahar | timeline score: 0 | |
| Jan 1, 2018 at 1:11 | answer | added | Chander Dubedi | timeline score: 1 | |
| Dec 29, 2017 at 15:10 | answer | added | Dominique Boucher | timeline score: 0 | |
| Dec 22, 2017 at 11:32 | review | Close votes | |||
| Dec 22, 2017 at 11:37 | |||||
| Dec 22, 2017 at 11:27 | vote | accept | Ikenna | ||
| Dec 22, 2017 at 11:26 | history | edited | Paul White♦ | CC BY-SA 3.0 |
Updated from OP comment
|
| Dec 22, 2017 at 11:18 | history | edited | Paul White♦ | CC BY-SA 3.0 |
Incorporated comment
|
| S Dec 22, 2017 at 11:16 | history | suggested | Thom A |
Removed 2008 tag
|
|
| Dec 22, 2017 at 10:55 | answer | added | ttwis | timeline score: 8 | |
| Dec 22, 2017 at 10:55 | review | Suggested edits | |||
| S Dec 22, 2017 at 11:16 | |||||
| Dec 22, 2017 at 10:54 | answer | added | David Fowler | timeline score: 0 | |
| Dec 22, 2017 at 10:45 | history | migrated | from stackoverflow.com (revisions) | ||
| Dec 22, 2017 at 10:40 | history | asked | Ikenna | CC BY-SA 3.0 |