新增文章

文章标题分类内容

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--【功能权限管理】【高级】：【数据引入引出】

select * from t_ObjectAccess        where FGroupID    = 3     --【模块名称.权限名称】
   select * from t_ObjectType          where FObjectType = 2003  --【权限名称】
   select * from t_ObjectAccessType    where FObjectType = 2003  --【功能名称】
   
   select * from t_AccessControl   where FObjectType = 2003 and FUserID = 16399  order by FUserID,FObjectType,FObjectID  --【单据权限】【用户】

select * from t_ObjectAccess        where FGroupID    = 9     --【模块名称.权限名称】
   select * from t_ObjectType          where FObjectType = 2007  --【权限名称】
   select * from t_ObjectAccessType    where FObjectType = 2007  --【功能名称】
   
   select * from t_AccessControl   where FObjectType = 2007 and FUserID = 16399  order by FUserID,FObjectType,FObjectID  --【单据权限】【用户】

select * from t_GroupAccessType     where FGroupID    IN ( 2101,2102 )                     --【模块名称】
   select * from t_ObjectAccess        where FGroupID    IN ( 2101,2102 ) and FObjectID = 0   --【模块名称.权限名称】
   select * from t_ObjectType          where FObjectType IN ( 4100      ) and FObjectID = 0   --【权限名称】
   
   
   select * from t_ObjectAccess        where FObjectID = 210000001   --【模块名称.权限名称】
   select * from t_ObjectType          where FObjectID = 210000001   --【权限名称】
   select * from t_ObjectAccessType    where FObjectID = 210000001   --【功能名称】
   
   
   select * from t_GroupAccess     where FUserID   = 16399   --【模块权限】【用户】
   select * from t_AccessControl   where FObjectID = 210000001  order by FUserID,FObjectType,FObjectID  --【单据权限】【用户】