权限--查询用户字段权限原创
56人赞赏了该文章
214次浏览
编辑于2024年06月07日 12:37:44
一、通过用户字段权限报表,可以查询到具体单据的某个字段权限
二、通过sql脚本查询
SELECT t0.FUSERID,t0.FName,t1.FORGID,t2.FNAME orgName ,t3.FROLEID,t4.FNAME roleName,t5.FOBJECTTYPEID,t7.Fname objectName, case WHEN t6.FVIEW is null then '有权' when t6.FVIEW =1 then '无权' else '禁用' end 'ViewPermission', case WHEN t6.FEDIT is null then '有权' when t6.FEDIT =1 then '无权' else '禁用' end 'EditPermission' ,t6.FFIELDKEY FROM T_SEC_USER t0 INNER JOIN T_SEC_USERORG t1 ON t1.FUSERID = t0.FUSERID left join T_ORG_ORGANIZATIONS_L t2 on t2.FORGID = t1.FORGID and t2.FLOCALEID=2052 INNER JOIN T_SEC_USERROLEMAP t3 ON t3.FENTITYID = t1.FENTITYID left join T_SEC_ROLE_L t4 on t4.FROLEID = t3.FROLEID and t4.FLOCALEID=2052 LEFT JOIN T_SEC_FIELDPERMISSION t5 ON t5.FROLEID = t3.FROLEID LEFT JOIN T_SEC_FIELDPERMISSIONENTRY t6 ON t6.FITEMID = t5.FITEMID left join V_META_OBJECTTYPE_L t7 on t7.FID = t5.FOBJECTTYPEID and t7.FLOCALEID=2052 WHERE t0.FName = '用户名' AND t5.FOBJECTTYPEID ='单据formId'
推荐阅读