用户权限数据库设计
来源:互联网 发布:淘宝订单清洗退钱么 编辑:程序博客网 时间:2024/05/17 03:49
SELECT * FROM
(
(SELECT DISTINCT( r.MenuId ) AS MenuId
FROM Privilege_RolesAuthority r
WHERE r.RoleID IN (SELECT u.RoleId
FROM aspnet_UsersInRoles u
WHERE u.UserId = 'dd65768b-935f-464c-b4f1-d1421e408c0d'))
UNION
(SELECT ParentId AS MenuId
FROM Settings_Catalog
WHERE MenuId IN (SELECT DISTINCT( r.MenuId )
FROM Privilege_RolesAuthority r
WHERE r.RoleID IN (SELECT u.RoleId
FROM aspnet_UsersInRoles u
WHERE u.UserId = 'dd65768b-935f-464c-b4f1-d1421e408c0d')))
UNION
(SELECT parentid AS MenuId
FROM Settings_Catalog
WHERE MenuId IN (SELECT parentid
FROM Settings_Catalog
WHERE MenuId IN (SELECT DISTINCT( r.MenuId )
FROM Privilege_RolesAuthority r
WHERE r.RoleID IN (SELECT u.RoleId
FROM aspnet_UsersInRoles u
WHERE u.UserId = 'dd65768b-935f-464c-b4f1-d1421e408c0d'))))
) tt1
LEFT JOIN Settings_Catalog catname
ON tt1.MenuId = catname.Menuid
WHERE catname.Parentid = 9000
AND catname.MenuEnable = 1
ORDER BY catname.Idx;
(
(SELECT DISTINCT( r.MenuId ) AS MenuId
FROM Privilege_RolesAuthority r
WHERE r.RoleID IN (SELECT u.RoleId
FROM aspnet_UsersInRoles u
WHERE u.UserId = 'dd65768b-935f-464c-b4f1-d1421e408c0d'))
UNION
(SELECT ParentId AS MenuId
FROM Settings_Catalog
WHERE MenuId IN (SELECT DISTINCT( r.MenuId )
FROM Privilege_RolesAuthority r
WHERE r.RoleID IN (SELECT u.RoleId
FROM aspnet_UsersInRoles u
WHERE u.UserId = 'dd65768b-935f-464c-b4f1-d1421e408c0d')))
UNION
(SELECT parentid AS MenuId
FROM Settings_Catalog
WHERE MenuId IN (SELECT parentid
FROM Settings_Catalog
WHERE MenuId IN (SELECT DISTINCT( r.MenuId )
FROM Privilege_RolesAuthority r
WHERE r.RoleID IN (SELECT u.RoleId
FROM aspnet_UsersInRoles u
WHERE u.UserId = 'dd65768b-935f-464c-b4f1-d1421e408c0d'))))
) tt1
LEFT JOIN Settings_Catalog catname
ON tt1.MenuId = catname.Menuid
WHERE catname.Parentid = 9000
AND catname.MenuEnable = 1
ORDER BY catname.Idx;
0 0
- 用户权限的数据库设计
- 用户权限数据库设计
- 用户权限数据库设计
- 数据库设计-用户权限
- 用户权限管理数据库设计
- 用户权限数据库设计解决方案
- 关于用户权限的数据库设计
- RBAC用户权限管理数据库设计
- RBAC用户权限管理数据库设计
- 后台管理用户权限数据库设计
- RBAC用户权限管理数据库设计
- RBAC用户权限管理数据库设计
- RBAC用户权限管理数据库设计
- RBAC用户权限管理数据库设计
- RBAC用户权限管理数据库设计
- RBAC用户权限管理数据库设计
- RBAC用户权限管理数据库设计
- 用户权限设计(一)-数据库设计
- MongoDB_Java连接mongo 在集合中插入文档
- css
- 使用gradle区分开发环境
- Event分发源码分析(五)
- TypeScript版本总是显示1.0的问题
- 用户权限数据库设计
- CString转换成两个整型
- MFC中用CFtpFileFind去遍历目录出现问题
- Hello MySQL
- python基础语法(11)类下
- 运用“孤独九剑”解决项目实际问题(三)
- ExpandableListView实现商品列表折叠
- 线性表之单链表
- 继续研究socket模拟浏览器发送http请求 大家帮忙