用友 ERP权限表

SELECT cAuth_Id ,

cAuth_Name ,

ISNULL(cSub_Id, '') AS csub_id ,

cSupAuth_Id ,

iGrade ,

ISNULL(cAuthType, '') AS cAuthType ,

ISNULL(bEndGrade, 0) AS bEndGrade ,

iOrder

FROM UFDATA_020_2020..UA_Auth WITH ( NOLOCK )

WHERE csub_id IN ( SELECT cSub_Id

FROM UFSystem..UA_SubSys WITH ( NOLOCK )

WHERE cSub_Id <> N'AA' )

AND cAuth_Id NOT IN ( SELECT cAuth_Id

FROM UFSystem..ua_auth_base WITH ( NOLOCK )

WHERE cAcc_Id IS NULL )

UNION ALL

SELECT cAuth_Id ,

cAuth_Name ,

ISNULL(cSub_Id, '') AS csub_id ,

cSupAuth_Id ,

iGrade ,

ISNULL(cAuthType, '') AS cAuthType ,

ISNULL(bEndGrade, 0) AS bEndGrade ,

iOrder

FROM UA_Auth WITH ( NOLOCK )

WHERE csub_id IN ( SELECT cSub_Id

FROM UA_SubSys WITH ( NOLOCK )

WHERE cSub_Id <> N'AA' )

AND cAuth_Id NOT IN ( N'AS0130', N'AS01301', N'AS01302', N'DP0301',

N'DP0302', N'DP1801', N'DP1001', N'DPTAB_1',

N'RE', N'ADMIN' )

AND cAcc_Id IS NULL

ORDER BY iOrder;