(FAQ)用户类型或者关联职员不能修改
金蝶云社区
2人赞赏了该文章
1,124次浏览
编辑于2015年03月02日 00:00:00
【问题】: (FAQ)用户类型或者关联职员不能修改
版本: 7.0.1
模块: 安全管理
【答复】:
用户如果已经关联权限和角色就不能修改类型和关联职员。 查看用户关联的权限和角色，进行删除，修改完类型或关联职员之后再重新分配。有的时候由于用户的组织范围比较多，不方便查看，可以用脚本查询没有删除的权限项和角色，再到页面上进行删除。执行脚本如下： select Fuser.fname_l2 as 用户实名,Fperm.falias_l2 as 权限,case UserOrgPerm.fpermtype when 10 then '操作权' when 20 then '禁止权' when 30 then '授权权' end as 权限类型,Forg.fname_l2 as 组织,'无' as 角色 from T_PM_UserOrgPerm UserOrgPerm inner join t_pm_user FUser on UserOrgPerm.FOwner =FUser.fid INNER join t_org_baseunit Forg on UserOrgPerm.FOrgID = Forg.fid INNER join t_pm_permitem Fperm ON UserOrgPerm.FPermItemID = Fperm.fid where Fuser.fnumber='用户名' UNION all SELECT FUser.fname_l2 as 用户实名,Fperm.falias_l2 as 权限,case RolePerm.fpermtype when 10 then '操作权' when 20 then '禁止权' when 30 then '授权权' end as 权限类型,Forg.fname_l2 as 组织,FRole.fname_l2 as 角色 FROM T_PM_RolePerm RolePerm INNER JOIN T_PM_UserRoleOrg UserRoleOrg ON UserRoleOrg.FRoleID = RolePerm.FRoleID INNER JOIN T_PM_PermItem Fperm ON Fperm.FID = RolePerm.FPermItemID INNER JOIN T_PM_User FUser ON UserRoleOrg.FUserID = FUser.fid INNER JOIN T_ORG_BaseUnit Forg on UserRoleOrg.FOrgID = Forg.fid INNER JOIN T_PM_Role FRole ON FRole.FID=RolePerm.FRoleID where Fuser.fnumber='用户名'
版本: 7.0.1
模块: 安全管理
【答复】:
用户如果已经关联权限和角色就不能修改类型和关联职员。 查看用户关联的权限和角色，进行删除，修改完类型或关联职员之后再重新分配。有的时候由于用户的组织范围比较多，不方便查看，可以用脚本查询没有删除的权限项和角色，再到页面上进行删除。执行脚本如下： select Fuser.fname_l2 as 用户实名,Fperm.falias_l2 as 权限,case UserOrgPerm.fpermtype when 10 then '操作权' when 20 then '禁止权' when 30 then '授权权' end as 权限类型,Forg.fname_l2 as 组织,'无' as 角色 from T_PM_UserOrgPerm UserOrgPerm inner join t_pm_user FUser on UserOrgPerm.FOwner =FUser.fid INNER join t_org_baseunit Forg on UserOrgPerm.FOrgID = Forg.fid INNER join t_pm_permitem Fperm ON UserOrgPerm.FPermItemID = Fperm.fid where Fuser.fnumber='用户名' UNION all SELECT FUser.fname_l2 as 用户实名,Fperm.falias_l2 as 权限,case RolePerm.fpermtype when 10 then '操作权' when 20 then '禁止权' when 30 then '授权权' end as 权限类型,Forg.fname_l2 as 组织,FRole.fname_l2 as 角色 FROM T_PM_RolePerm RolePerm INNER JOIN T_PM_UserRoleOrg UserRoleOrg ON UserRoleOrg.FRoleID = RolePerm.FRoleID INNER JOIN T_PM_PermItem Fperm ON Fperm.FID = RolePerm.FPermItemID INNER JOIN T_PM_User FUser ON UserRoleOrg.FUserID = FUser.fid INNER JOIN T_ORG_BaseUnit Forg on UserRoleOrg.FOrgID = Forg.fid INNER JOIN T_PM_Role FRole ON FRole.FID=RolePerm.FRoleID where Fuser.fnumber='用户名'
推荐阅读