You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
15 lines
634 B
15 lines
634 B
-- 作废审核菜单补授权：经侦管理员（已执行过 20260708 的环境可单独跑本脚本）
|
|
-- 超级管理员 admin 账号无需绑定，重新登录即可看到全部菜单
|
|
|
|
INSERT INTO t_role_menu (role_id, menu_id)
|
|
SELECT r.role_id, m.menu_id
|
|
FROM t_role r
|
|
JOIN t_menu m ON m.deleted_flag = 0
|
|
WHERE r.role_code = 'JZ_ADMIN'
|
|
AND (
|
|
m.path = '/business/alarm/void-audit-list'
|
|
OR m.parent_id IN (SELECT menu_id FROM t_menu WHERE path = '/business/alarm/void-audit-list' AND deleted_flag = 0)
|
|
)
|
|
AND NOT EXISTS (
|
|
SELECT 1 FROM t_role_menu rm WHERE rm.role_id = r.role_id AND rm.menu_id = m.menu_id
|
|
);
|
|
|