select top 100 * from t_ObjectType where FObjectID=1
对象权限类型表,细分权限的新增、查看等权限,权限组用Findex控制,权限表用FAccessMask控制
select * from t_ObjectAccessType
1.权限控制
权限控制表,用户对对象拥有的权限,此对象所有权限的或运算
select * from t_AccessControl
查看用户权限
select u.fuserid,c.FName,b.FName,b.FDescription,* from t_AccessControl a
join t_ObjectAccessType b on a.FObjectType=b.FObjectType and a.FObjectID=b.FObjectID
join t_ObjectType c on a.FObjectType=c.FObjectType and a.FObjectID=c.FObjectID
join t_user u on u.FUserID=a.FUserID
where u.fname='dhj' and b.FAccessMask&a.FAccessMask>0
order by c.FName,b.FName
2.权限组控制
添加用户权限组时将此组的权限添加到权限控制表中
用户组权限类表,权限组名称
select * from t_GroupAccessType
权限组对应的权限
select * from t_ObjectAccess
用户组权限表
select * from t_GroupAccess
查看权限组权限
select u.fuserid,e.FSubSys,FAccess,d.fname,c.fname,* from t_GroupAccess a
join t_ObjectAccess b on a.FGroupID=b.FGroupID
join t_ObjectAccessType c on b.fobjectid=c.fobjectid and b.fobjecttype=c.fobjecttype and b.findex=c.findex
join t_ObjectType d on c.FObjectType=d.FObjectType and c.FObjectID=d.FObjectID
join t_GroupAccessType e on e.FGroupID=a.FGroupID
join t_user u on u.FUserID=a.FUserID
where u.fname='dhj'
评论