-- =============================================
|
-- 第六步:分配权限给管理员
|
-- =============================================
|
|
INSERT INTO sys_role_menu (role_id, menu_id)
|
SELECT 1, menu_id FROM sys_menu WHERE menu_name LIKE '%常见问题%';
|
|
-- 验证
|
SELECT COUNT(*) as '权限数量' FROM sys_role_menu WHERE menu_id IN (SELECT menu_id FROM sys_menu WHERE menu_name LIKE '%常见问题%');
|