删掉不需要的roleid scm
SELECT * FROM sys_menu where parent_id='2' and (id=13 or id=2) SELECT * from sys_role_menu where role_id=1 and menu_id not in( 13,2,14,17,20,30,4,3,56,67,7 ) delete from sys_role_menu where role_id=1 and menu_id not in( 13,2,14,17,20,30,4,3,56,67,7 ) -- delete from sys_role_menu where role_id='afb46d9c530042788c6ab8e4a60b4b65'