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

写好后 做个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

本文出自 “spike” 博客