· 8 years ago · Jul 12, 2018, 11:08 PM
1DROP TABLE IF EXISTS #Groups
2CREATE TABLE #Groups
3(
4 [Name] NVARCHAR(30) NOT NULL PRIMARY KEY
5)
6
7INSERT #Groups ([Name]) VALUES
8(N'ORGDBDevelopers'),
9(N'ORGDBFullAccess'),
10(N'ORGDBReadOnly')
11
12SELECT g.[Name], IS_MEMBER(g.[Name])
13FROM #Groups g
14
15ORGDBReadOnly
16
17EXEC xp_logininfo N'ORGDBFullAccess', 'members'
18
19ORGDBFullAccess
20
21DBFullAccess