Security Reporting for SQL Server Analysis Services

Listing 2: xp_enumgroups Stored Procedure Used to Extract Local Group Membership

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [AMOSecurityUDM].[bAMOSecurityDefinition](
	[role] [varchar](50) NULL,
	[CubeDatabase] [varchar](50) NULL,
	[Cube] [varchar](50) NULL,
	[CubeAccessCode] [varchar](50) NULL,
	[RoleMember] [varchar](50) NULL
)