金蝶k3异常用户清理sql

钟逸 SQL 2024-04-14 17:49:34 53

金蝶K3异常用户清理操作旨在清除系统中长时间未使用的异常用户，优化系统性能和数据安全。以下介绍金蝶K3异常用户清理的完整操作指南。

SQL语句

DELETE FROM SYUSER WHERE CUSERNO NOT IN (
  SELECT DISTINCT CUSERNO
  FROM T_ORDER_OP
  UNION
  SELECT DISTINCT CUSERNO
  FROM T_ORDER_CHECK
  UNION
  SELECT DISTINCT CUSERNO
  FROM T_STK_TRAN
  UNION
  SELECT DISTINCT CUSERNO
  FROM T_STK_CHECK
  UNION
  SELECT DISTINCT CUSERNO
  FROM T_STK_CHECK_DETAIL
  UNION
  SELECT DISTINCT CUSERNO
  FROM T_STK_CHECK_RESULT
  UNION
  SELECT DISTINCT CUSERNO
  FROM T_STK_CHECK_RESULT_DETAIL
  UNION
  SELECT DISTINCT CUSERNO
  FROM T_STK_CHECK_TASK
  UNION
  SELECT DISTINCT CUSERNO
  FROM T_STK_MNCHECK
  UNION
  SELECT DISTINCT CUSERNO
  FROM T_STK_PLAN
  UNION
  SELECT DISTINCT CUSERNO
  FROM T_STK_PLAN_DETAIL
  UNION
  SELECT DISTINCT CUSERNO
  FROM T_STK_PLAN_MNCHECK
  UNION
  SELECT DISTINCT CUSERNO
  FROM T_STK_PLAN_PACKAGE
  UNION
  SELECT DISTINCT CUSERNO
  FROM T_STK_PLAN_PACKAGE_DETAIL
  UNION
  SELECT DISTINCT CUSERNO
  FROM T_STK_PLAN_PACKAGE_MNCHECK
  UNION
  SELECT DISTINCT CUSERNO
  FROM T_STK_SCRAP
  UNION
  SELECT DISTINCT CUSERNO
  FROM T_STK_STOCK
  UNION
  SELECT DISTINCT CUSERNO
  FROM T_STK_STOCK_DETAIL
  UNION
  SELECT DISTINCT CUSERNO
  FROM T_STK_STOCK_MNCHECK
  UNION
  SELECT DISTINCT CUSERNO
  FROM T_STK_SWAP
  UNION
  SELECT DISTINCT CUSERNO
  FROM T_STK_SWAP_DETAIL
  UNION
  SELECT DISTINCT CUSERNO
  FROM T_STK_SWAP_MNCHECK
  UNION
  SELECT DISTINCT CUSERNO
  FROM T_STK_TRANSFER
  UNION
  SELECT DISTINCT CUSERNO
  FROM T_STK_TRANSFER_DETAIL
  UNION
  SELECT DISTINCT CUSERNO
  FROM T_STK_TRANSFER_MNCHECK
  UNION
  SELECT DISTINCT CUSERNO
  FROM T_WMS_DISTRIBUTION
  UNION
  SELECT DISTINCT CUSERNO
  FROM T_WMS_DISTRIBUTION_DETAIL
  UNION
  SELECT DISTINCT CUSERNO
  FROM T_WMS_PICK
  UNION
  SELECT DISTINCT CUSERNO
  FROM T_WMS_PICK_DETAIL
  UNION
  SELECT DISTINCT CUSERNO
  FROM T_WMS_PICK_PACKAGE
  UNION
  SELECT DISTINCT CUSERNO
  FROM T_WMS_PUTAWAY
  UNION
  SELECT DISTINCT CUSERNO
  FROM T_WMS_PUTAWAY_DETAIL
  UNION
  SELECT DISTINCT CUSERNO
  FROM T_WMS_RETURN
  UNION
  SELECT DISTINCT CUSERNO
  FROM T_WMS_RETURN_DETAIL
  UNION
  SELECT DISTINCT CUSERNO
  FROM T_WMS_RETURN_PACKAGE
  UNION
  SELECT DISTINCT CUSERNO
  FROM T_WMS_SHIP
  UNION
  SELECT DISTINCT CUSERNO
  FROM T_WMS_SHIP_DETAIL
  UNION
  SELECT DISTINCT CUSERNO
  FROM T_WMS_TRANSFER
  UNION
  SELECT DISTINCT CUSERNO
  FROM T_WMS_TRANSFER_DETAIL
  UNION
  SELECT DISTINCT CUSERNO
  FROM T_WMS_TRANSFER_PACKAGE
) AND LAST_LOGIN_DATE < GETDATE() - 90;