| 12345678910111213141516171819202122232425 |
- -- S6 Phase 1B 收尾 · UATAdminA 所属租户(838257186181189)最小菜单授权(幂等)
- -- 仅补齐 S6「生产指令单列表」(MenuId=1329016010001) 正常显示所必需的、当前缺失的两级授权:
- -- 缺失级 = 生产记录管理(1322000000019) + 生产指令单列表(1329016010001)
- -- (上级 Ai-DOP(1320990000101) / S6生产执行(1321000007000) 该租户+角色已授权,不重复)
- -- 角色 = UATAdminA 的 UAT业务操作员(838258976469061)(与兄弟菜单 过程检验单列表 现行授权模式一致)
- -- 严格范围:只此租户、只此角色、只此两菜单;不全量授权、不动其他租户/角色/权限模型、不删除既有关系。
- -- 幂等:NOT EXISTS 保护;固定 Id 防重复。
- -- ① SysTenantMenu(租户 838 缺失的两级)
- INSERT INTO SysTenantMenu (Id, TenantId, MenuId)
- SELECT 3000000000000021001, 838257186181189, 1322000000019
- WHERE NOT EXISTS (SELECT 1 FROM SysTenantMenu WHERE TenantId=838257186181189 AND MenuId=1322000000019);
- INSERT INTO SysTenantMenu (Id, TenantId, MenuId)
- SELECT 3000000000000021002, 838257186181189, 1329016010001
- WHERE NOT EXISTS (SELECT 1 FROM SysTenantMenu WHERE TenantId=838257186181189 AND MenuId=1329016010001);
- -- ② SysRoleMenu(UAT业务操作员 缺失的两级)
- INSERT INTO SysRoleMenu (Id, RoleId, MenuId)
- SELECT 3000000000000021003, 838258976469061, 1322000000019
- WHERE NOT EXISTS (SELECT 1 FROM SysRoleMenu WHERE RoleId=838258976469061 AND MenuId=1322000000019);
- INSERT INTO SysRoleMenu (Id, RoleId, MenuId)
- SELECT 3000000000000021004, 838258976469061, 1329016010001
- WHERE NOT EXISTS (SELECT 1 FROM SysRoleMenu WHERE RoleId=838258976469061 AND MenuId=1329016010001);
|