KIS/K3系列异常用户清理脚本

脚本包含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一起设置打印,非套打*/