Q:How do I find out what web reports belong to what permission groups?
A:You can run this T-SQL to find which roles will grant access to a report.
DECLARE @reportTitle VARCHAR(MAX) = 'Debit Memo'
DECLARE @rptId varchar(MAX),@pGroup varchar(MAX)
SELECT @rptId = rptID,@pGroup = paramGroup FROM [MnxReports] WHERE rptTitle LIKE '%'+ @reportTitle +'%'
SELECT rptId,rptTitle,rptTitleLong,rptDescription FROM [MnxReports] WHERE rptId=@rptId
DECLARE @rTags varchar(10)
SELECT @rTags=fksTagId FROM [MnxReportTags] WHERE [rptId]=@rptId
SELECT RoleName FROM [aspnet_Roles] WHERE roleId IN (SELECT fkRoleId FROM [aspmnx_RoleSystemTags] WHERE fksTagId=@rTags)
Simply change the 'Debit Memo' to the title of the report you want.
|