問題現(xiàn)象：用友U8ERP軟件用戶權(quán)限復(fù)制？

在sql server的查詢分析器里面

1.、打開系統(tǒng)庫

use ufsystem

2、先將要復(fù)制的權(quán)限備份下，假設(shè)新帳套為561，老帳套是555

SELECT * into ua_holdauth_5612011

FROM UA_HoldAuth

WHERE (iYear = 2011) AND (cAcc_Id = 561)

3、刪除新帳套中的默認(rèn)權(quán)限，放心刪除吧 上面?zhèn)浞萘?/p>

delete from ua_holdauth where iyear=2011 and cacc_id= 561

復(fù)制555的權(quán)限到561

4、INSERT INTO UA_HoldAuth

(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser)

SELECT '561' AS Expr1, '2011' AS Expr2, cUser_Id, cAuth_Id, iIsUser

FROM UA_HoldAuth

WHERE (iYear = 2010) AND (cAcc_Id = 555)