用友U8ERP软件用户权限复制

问题现象：用友U8ERP软件用户权限复制？

在sql server的查询分析器里面

微信号：yyrjlls
加微咨询技术问题！
复制微信号

1.、打开系统库

use ufsystem

2、先将要复制的权限备份下，假设新帐套为561，老帐套是555

SELECT * into ua_holdauth_5612011

FROM UA_HoldAuth

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

3、删除新帐套中的默认权限，放心删除吧 上面备份了

delete from ua_holdauth where iyear=2011 and cacc_id= 561

复制555的权限到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)