新增文章

文章标题分类内容

------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--【视图】 删除

if exists ( select * from sys.views where object_id = OBJECT_ID(N'dbo.a_ObjectAccess') )
               drop     view                                         dbo.a_ObjectAccess
   go

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--【视图】 a_ObjectAccess 功能权限

create view dbo.a_ObjectAccess
   as 
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
   select a1.FGroupID
   
         ,isnull(a2.FSubSys,'') FGroupName
         ,isnull(a2.FAccess,'') FAccess
         
         ,a1.FObjectType
         ,isnull(a3.FName,'')  FObjectTypeName
         
         ,a1.FObjectID
         ,isnull(a4.FName,'')  FObjectName
         
         ,a1.FIndex
         ,isnull(CONVERT(varchar(50),a5.FName      )  ,'')  FAccessName
         ,isnull(CONVERT(varchar(50),a5.FAccessMask)  ,'')  FAccessMask
         
   from       t_ObjectAccess      a1
   left join  t_GroupAccessType   a2 on a1.FGroupID    = a2.FGroupID
   left join  t_ObjectType        a3 on a1.FObjectType = a3.FObjectType  AND a3.FObjectID  = 0
   left join  t_ObjectType        a4 on a1.FObjectType = a4.FObjectType  AND a1.FObjectID = a4.FObjectID
   left join  t_ObjectAccessType  a5 on a1.FObjectType = a5.FObjectType  AND a1.FObjectID = a5.FObjectID AND a1.FIndex = a5.FIndex

/*
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
   select * from a_ObjectAccess   where FAccess LIKE '%管理权%' AND  FObjectTypeName LIKE '%%' AND  FObjectName LIKE '%%'  
   
------------------------------------------------------------------------------------------------------------------------------------------------------------------------

select * from t_ObjectAccess                          --【模块名称.权限名称】
   select * from t_GroupAccessType                       --【模块名称】
   select * from t_ObjectType       where FObjectID = 0  --【权限名称】
   select * from t_ObjectType                            --【权限名称】
   select * from t_ObjectAccessType                      --【功能名称】
   
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
*/
go