oracle数据库怎样让权限具体到操作某个表，或者某列？

kingdee_role（角色名）

TotalPayment_Tmp_Table（表名）

Work_Status,End_Date（表中字段）

给角色赋予权限

grant create session to kingdee_role;
grant update on TotalPayment_Tmp_Table to kingdee_role;
grant select  on TotalPayment_Tmp_Table to kingdee_role;
grant insert on TotalPayment_Tmp_Table to kingdee_role;
grant update(Work_Status,End_Date) on ANNUITY_PERSON to kingdee_role;

给用户赋予角色

create user kingdee identified by jingdie ;
grant kingdee_role to kingdee;

注意要点：1.查询的时候要加上xx.表名

                    2.不能给列赋予查询权限，可通过创建视图来解决