异常用户清理脚本

异常用户清理脚本原创

prekingder

20人赞赏了该文章 2,435次浏览编辑于2021年06月04日 14:53:21

脚本包含k3,KIS 两类产品。如果执行的时候报错对象名 'XX' 无效请注释该行继续执行下面的行即可。用户异常使用异常清理工具无效的使用下面脚本去试试。

delete ICClassUserProfile WHERE FUserID=(select FUserID from t_user where Fname='用户名')

delete ICClassUserProfileEntry where Fschemeid not in(select Fschemeid from ICClassUserProfile )

delete ICSchemeProfile WHERE FUserID=(select FUserID from t_user where Fname='用户名')

delete ICSchemeProfileEntry where Fschemeid not in(select Fschemeid from ICSchemeProfile)

delete t_UserProfile WHERE FUserID=(select FUserID from t_user where Fname='用户名')

delete ICReportProfile WHERE FUserID=(select FUserID from t_user where Fname='用户名')

delete ICBillNote where FPreparerId =(select FUserID from t_user where Fname='用户名')/*套打*/

delete ICReportFormat WHERE FUserID=(select FUserID from t_user where Fname='用户名')

delete ICBillFormat WHERE FUserID=(select FUserID from t_user where Fname='用户名') /*与t_UserSetting一起设置打印,非套打*/

delete t_UserSetting WHERE FUserID=(select FUserID from t_user where Fname='用户名')/*与ICBillFormat一起设置打印,非套打*/

赞 20