---�ǿ�Ȩ�ޱ�

--����Ȩ��: T_SEC_OBJECTTYPEPERMISSION 
--Ȩ�ޱ�: T_SEC_FIELDPERMISSION 
--Ȩ�����: t_sec_permissionItem
--����Ȩ�ޱ�: T_SEC_FUNCPERMISSION
--����Ȩ�����: T_SEC_FUNCPERMISSIONENTRY
--�ֶ�Ȩ�ޱ�: T_SEC_FIELDPERMISSION
--�ֶ�Ȩ�����: T_SEC_FIELDPERMISSIONENTRY
--�û���֯��: T_SEC_USERORG
--��ɫ��: select * from T_SEC_ROLE

---Ȩ�޶����
--select * from T_SEC_PERMISSIONOBJECT 
--select * from T_SEC_PERMISSIONOBJECT_L where FNAME like '%Gold%'
------------------------------------------------------------------------------
select 
obj.FITEMID
,obj.FFORBIDSTATUS,obj.FNUMBER,obj.FSUBSYSTEMID,obj.FISSYSPRESET
,obj_L.FNAME
,obje.FPERMISSIONITEMID
,pm.FNAME
 from
T_SEC_PERMISSIONOBJECT obj
left join T_SEC_PERMISSIONOBJECT_L obj_L on obj.FITEMID=obj_L.FITEMID
left join T_SEC_PERMISSIONOBJECTENTRY obje on obj.FITEMID=obje.FITEMID  --Ȩ�޶����ϸ
left join T_SEC_PERMISSIONITEM_L  pm on pm.FITEMID=obje.FPERMISSIONITEMID and pm.FLOCALEID=2052 --Ȩ�޶����ϸ���
where obj_L.FNAME like '%Gold%'


--Ȩ�����
select * from T_SEC_PERMISSIONITEM  
select * from T_SEC_PERMISSIONITEM_L where FNAME like '%�鿴%'
------------------------------------------------------------------------------
select
a.FITEMID,a.FSEQ,a.FNUMBER,a_L.FNAME,a.FDESCRIPTION
,a.FFORBIDSTATUS,a.FGROUP,a.FISSYSPRESET,a_L.FLOCALEID

from T_SEC_PERMISSIONITEM  a
left join T_SEC_PERMISSIONITEM_L a_L on a.FITEMID=a_L.FITEMID
where a_L.FNAME = '�鿴'
and a_L.FLOCALEID=2052



---��ǰ���ݶ�Ӧ��Ȩ�޶����Ȩ����

--�û�,��ɫ,�Ƿ����Ȩ�޶����Ȩ����



--��ɫ��
select 
ro.FROLEID,ro.FNUMBER,ro_L.FNAME,ro.FDESCRIPTION
,ro.FCREATEDATE
--,* 
from T_SEC_ROLE ro
left join T_SEC_ROLE_L ro_L on ro.FROLEID=ro_L.FROLEID and ro_L.FLOCALEID=2052
where ro.FDOCUMENTSTATUS='C'
and ro.FFORBIDSTATUS='A'
order by ro.FCREATEDATE  desc


--ҵ�����-Ȩ�޶����
select * from [T_SEC_OBJECTTYPEPERMISSION]
where FOBJECTTYPEID='653bc3d054fbf6'

--select * from T_SEC_FunPermissionObject

--���ܸ�T_SEC_FunPermissionObject��Ȩ��Χ���йء�
--�����ܸ�T_SEC_ObjectTypePermissionҵ�����Ȩ�޶������FVisible��Ȩ����ɼ��������йء�