获取用户划分权限的模板列表
SELECT DISTINCT
u.id ,
u.username,
u.realname,
auo.id ,
auo.displayname,
COALESCE(auos.path, auo.path) AS path
FROM
FINE_USER u
INNER JOIN FINE_USER_ROLE_MIDDLE urm ON u.id = urm.userid
LEFT JOIN fine_custom_role cr ON urm.roleid = cr.id
INNER JOIN FINE_AUTHORITY AU ON urm.roleid = au.roleid OR u.id = au.roleid
INNER JOIN FINE_AUTHORITY_OBJECT AUO ON AU.authorityentityid = auo.id
LEFT JOIN FINE_AUTHORITY_OBJECT AUOS ON AUOS.fullpath LIKE CONCAT('%', auo.id , '%')
WHERE
u.username = 'WB-XIEQ01'
AND (auos.path IS NOT NULL OR auo.path IS NOT NULL)
52 评论
获取用户划分权限的模板列表
SELECT DISTINCT
u.id ,
u.username,
u.realname,
auo.id ,
auo.displayname,
COALESCE(auos.path, auo.path) AS path
FROM
FINE_USER u
INNER JOIN FINE_USER_ROLE_MIDDLE urm ON u.id = urm.userid
LEFT JOIN fine_custom_role cr ON urm.roleid = cr.id
INNER JOIN FINE_AUTHORITY AU ON urm.roleid = au.roleid OR u.id = au.roleid
INNER JOIN FINE_AUTHORITY_OBJECT AUO ON AU.authorityentityid = auo.id
LEFT JOIN FINE_AUTHORITY_OBJECT AUOS ON AUOS.fullpath LIKE CONCAT('%', auo.id , '%')
WHERE
u.username = 'WB-XIEQ01'
AND (auos.path IS NOT NULL OR auo.path IS NOT NULL)
赞 0 2025-04-08 09:33
finedb是实时的吗？操作立马会更新数据吗
赞 0 2024-07-30 11:19
问下帆软11版本模板主题的数据存在哪张表？
赞 0 2024-01-12 17:46
有大佬知道吗
赞 0 2024-01-23 16:10
能在数据库里查到当前设计器的模板(报表)清单吗？想知道模板总数
赞 0 2023-10-19 10:18
目录管理的表关联关系是什么样的，怎么查看目录管理下各层级目录挂载的报表及路径等信息呢
赞 1 2023-07-31 11:37
请问大佬知道吗？
赞 0 2023-09-21 09:46