78243b69-5bd6-43c6-b5e6-0e9f84823601Page1setnocountondeclare@Fuseridintselect@Fuserid=Fuseridfromt_userwherefname='manager'--select@Fuseridifexists(select1fromsysobjectswherename='ICClassUserProfile'andxtype='u')begindeletefromICClassUserProfilewherefuserid=@Fuseridendifexists(select1fromsysobjectswherename='t_UserProfile'andxtype='u')begindeletefromt_UserProfilewherefuserid=@Fuseridendifexists(select1fromsysobjectswherename='ICReportProfile'andxtype='u')begindeletefromICReportProfilewherefuserid=@Fuseridendifexists(select1fromsysobjectswherename='ICPlanProfile'andxtype='u')begindeletefromICPlanProfilewherefuserid=@Fuseridendifexists(select1fromsysobjectswherename='ICPlanProfile'andxtype='u')begindeletefromICPlanProfilewherefuserid=@Fuseridendifexists(select1fromsysobjectswherename='ICSchemeProfile'andxtype='u')begindeletefromICSchemeProfilewherefuserid=@Fuseridendifexists(select1fromsysobjectswherename='icreportprofile'andxtype='u')begindeletefromicreportprofilewherefuserid=@Fuseridendifexists(select1fromsysobjectswherename='icreportformat'andxtype='u')begindeletefromicreportformatwherefuserid=@Fuserid--在这里修改需要清理个人信息的用户名78243b69-5bd6-43c6-b5e6-0e9f84823601Page2end