调整权限差异-用友T3

调整权限差异

微信号：yyrjlls
技术咨询，有偿服务！
复制微信号

原因分析：2用户在UA_HoldAuth中记录不同，可通过对比进行调整

问题解答：USE SYSTEMINSERT INTO UA_HoldAuth( CACC_ID,IYEAR,CUSER_ID,CAUTH_ID,IISUSER,CSUB_ID,CAUTHTYPE)SELECT CACC_ID,IYEAR,'042',CAUTH_ID,IISUSER,CSUB_ID,CAUTHTYPE FROM UA_HoldAuth WHERE CUSER_ID='003' AND IYEAR='2010' AND CACC_ID='001'AND CAUTH_ID IN(SELECT DISTINCT A.CAUTH_ID FROM (SELECT * FROM dbo.UA_HoldAuth WHERE CUSER_ID='003' AND IYEAR='2010' AND CACC_ID='001' AND CSUB_ID='SA')ALEFT OUTER JOIN (SELECT * FROM dbo.UA_HoldAuth WHERE CUSER_ID='TEST' AND IYEAR='2010' AND CACC_ID='001' AND CSUB_ID='SA')BON A.CAUTH_ID=B.CAUTH_ID WHERE ISNULL(B.CACC_ID,'')='')

本文链接：https://www.bbsufida.com/t3/21459.html