設
Table1存儲包括a,b,unit三個字段.用它存儲你所有數據,存儲在同一個表容易統計
建立視圖create view as select a,b from table1 where unit='总部'
create view as select a,b from table1 where unit='部门1'
create view as select a,b from table1 where unit='部门1'
然后用對每個視圖設你想設的權限.
Table1存儲包括a,b,unit三個字段.用它存儲你所有數據,存儲在同一個表容易統計
建立視圖create view as select a,b from table1 where unit='总部'
create view as select a,b from table1 where unit='部门1'
create view as select a,b from table1 where unit='部门1'
然后用對每個視圖設你想設的權限.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货