U852 快速登录企业门户的方法

yanzi1150

不知道各位是否有这种情况出现：用友登录企业门户时很慢，有时还进不去。
经过分析发现是一个叫UA_HoldAuth过大的原因
（此表好像是一个权限表，每次第个用户进入系统前都要读一次）
当你有很多用户又有很多见账套时这个表就用变得很大。
不知道各位有什么好的处理方法？

下面是我处理的方法，不知有没有后遗症？
(结果：登录企业门户速度变快了，用友的默认权限组没有了，所有权限自己设。
使用用友暂时没有发现什么问题。)

注意：没有看懂下面的SQL语句前请不要使用。
use ufsystem
delete
from ua_holdauth
where cuser_id='manager-gsp1'
or cuser_id='decision-001'
or cuser_id='decision-fi1'
or cuser_id='decision-l01'
or cuser_id='manager-em01'
or cuser_id='manager-fi01'
or cuser_id='manager-gsp1'
or cuser_id='manager-hr01'
or cuser_id='manager-mm01'
or cuser_id='manager-pu01'
or cuser_id='manager-qa01'
or cuser_id='manager-sa01'
or cuser_id='manager-st01'
or cuser_id='oper-em-0001'
or cuser_id='oper-fi-0001'
or cuser_id='oper-fi-0002'
or cuser_id='oper-fi-0061'
or cuser_id='oper-fi-0071'
or cuser_id='oper-fi-0021'
or cuser_id='oper-fi-0022'
or cuser_id='oper-fi-0031'
or cuser_id='oper-fi-0041'
or cuser_id='oper-fi-0011'
or cuser_id='oper-fi-0012'
or cuser_id='oper-fi-0051'
or cuser_id='oper-fi-0081'
or cuser_id='oper-fi-0082'
or cuser_id='oper-fi-0083'
or cuser_id='oper-hr-0001'
or cuser_id='oper-pp-0001'
or cuser_id='oper-pu-0001'
or cuser_id='oper-pu-0002'
or cuser_id='oper-pu-0003'
or cuser_id='oper-pu-0004'
or cuser_id='oper-qa-0001'
or cuser_id='oper-qa-0002'
or cuser_id='oper-qa-0003'
or cuser_id='oper-qa-0004'
or cuser_id='oper-qa-0005'
or cuser_id='oper-qa-0006'
or cuser_id='oper-qa-0007'
or cuser_id='oper-qa-0008'
or cuser_id='oper-qa-0009'
or cuser_id='oper-qa-0010'
or cuser_id='oper-qa-0011'
or cuser_id='oper-qa-0012'
or cuser_id='oper-sa-0001'
or cuser_id='oper-sa-0002'
or cuser_id='oper-sa-0003'
or cuser_id='oper-st-0001'
or cuser_id='oper-st-0002'
or cuser_id='oper-st-0003'
or cuser_id='oper-st-0004'
or cuser_id='oper-qa-0004'
or cuser_id='MANAGER-PUO1'