【问】1001进软件不能设置分部几个操作员的类别权限,也看不到类别? | ||
【适用版本】服装之星8 | 【模块】基础业务 | 【点击数】518 |
【知识编号】Z2012082800007 | ||
【问题描述】1001进软件不能设置分部几个操作员的类别权限,也看不到类别? |
use hbfsv8
go
delete t_sys_data_grant
insert into t_sys_data_grant (oper_id,item_clsno)
select oper_id,item_clsno from t_sys_operator,t_bd_item_cls where len(item_clsno)=2 and oper_id not in (select oper_id from t_sys_data_grant)
update t_sys_data_grant set data_grant = ‘1’