【问】后台操作员里没有删菜权限可选择?
【适用版本】食通天5	【模块】系统管理	【点击数】35
【知识编号】C2012051100035
【问题描述】后台操作员里没有删菜权限可选择?

【答】 升级软件或执行下面语句：
use issrestv5
go
if not exists (select 1 from cybr_sys_purview_second where ch_purviewno = ‘0741’)
 insert into cybr_sys_purview_second(ch_purviewno,vch_purviewname,ch_type,vch_memo)
 values(‘0741’, ‘删菜’, ‘1’, ‘前台删菜处理’)
 Insert into cybr_sys_oper_purview(vch_operID,ch_purviewno,ch_detailflag)
 select vch_operid, ‘0741’, ‘Y’ from cybr_sys_operator
 where not exists (select 1 from cybr_sys_oper_purview where vch_operid =cybr_sys_operator.vch_operid and ch_purviewno = ‘0741’)
go