查看 SQL2005 Reporting services文件夹报表权限

要整理报表权限，懒的一个一个去看 。

 写好后  做个 Mark ，有用的拿去，

VIEW:

create  view  eip_right
as
select a.path,a.Name ,b.Username   from catalog a  join (select c.policyid, c.UserID,d.Username from PolicyUserRole c
left join users d on c.userid=d.UserID)b on b.Policyid=a.Policyid 

SElECT:

Select name as 文件夹和报表,username as 用户组和用户 from eip_right  order by path