技术交流QQ群【JAVA,C++,Python,.NET,BigData,AI】:170933152
小工具:
清理权限相关的垃圾数据.
DELETE
FROM
sys_roleaccess
WHERE
access_id IN (
SELECT
access_id
FROM
(
SELECT
t.access_id
FROM
sys_roleaccess t
WHERE
t.access_id NOT IN (
SELECT
a.access_id
FROM
sys_access a
)
) t1
)
DELETE
FROM
sys_accessmenubus
WHERE
access_id IN (
SELECT
access_id
FROM
(
SELECT
t.access_id
FROM
sys_accessmenubus t
WHERE
t.access_id NOT IN (
SELECT
a.access_id
FROM
sys_access a
)
) t1
)