oracle同义词、授权、新增删除字段

A建同义词

create or replace synonym tabB for B. tabB;

create or replace synonym  tabB for B. tabB;

B授权

grant select,update,insert,delete on B.tabB to A;

grant select,update,insert,delete on B.tabB to A;

grant select,update,insert,delete on B.tabB to A;

添加字段

alter table tablename add 字段 char(32);

删除字段

alter table  tablename drop (字段);