主页 / dba / 问题 / 84406
Accepted
Heisenberg
Asked: 2014-12-06 01:01:45 +0800 CST

查看分配给每个用户的角色（报表服务器）

  • 772

无论如何，我是否可以列出在 ReportServer 数据库的不同文件夹中分配给每个用户的角色，并且在该 SQL 语句中我应该能够声明类似于 @User_Name报告用户的内容

ssrs permissions

1 个回答

  1. Best Answer

    从几乎相似的博客中找到我的答案 :) !!!

    DECLARE @UserName VARCHAR(200) = 'UserName' 

SELECT Rol.RoleName,Us.UserName ,Cat.PATH,Cat.[Name] ReportName,
CASE Cat.Type WHEN 1 THEN 'Folder' WHEN 2 THEN 'Report' 
WHEN 3 THEN 'Resource' WHEN 4 THEN 'Linked Report' 
WHEN 3 THEN 'Data Source' ELSE '' END AS CatalogType
,Cat.Description 
FROM Catalog Cat     --Parent
INNER JOIN Policies Pol 
ON Cat.PolicyID = Pol.PolicyID
INNER JOIN PolicyUserRole PUR 
ON Pol.PolicyID = PUR.PolicyID 
INNER JOIN Users Us 
ON PUR.UserID = Us.UserID 
INNER JOIN Roles Rol 
ON PUR.RoleID = Rol.RoleID
WHERE   Cat.Type in (1,2)
AND  ( Us.UserName LIKE @UserName  )
ORDER BY Cat.PATH
    • 0

相关问题