oracle 把某用户下的表权限授权给另一用户_jbqd

//把JBQDEDI读写权限 授权给JBQD
select 'Grant all on '||table_name||'to JBQD ;' from all_tables
where owner = upper('JBQDEDI');

//把当前登陆的用户表查询权限授权给b用户

select 'GRANT SELECT ON '||table_name||' to b;'  from user_tables

//如果上面方法失效，则这样试一下：
grant select,insert,update,delete on BGCD_EDI.EDI_ERROR_LOG to PDMP;
grant select,insert,update,delete on BGCD_EDI.EDI_JBQD_DECHEAD to PDMP;
grant select,insert,update,delete on BGCD_EDI.EDI_JBQD_DECCONTAINER to PDMP;
grant select,insert,update,delete on BGCD_EDI.EDI_JBQD_DECLICENSEDOCUS to PDMP;
grant select,insert,update,delete on BGCD_EDI.EDI_JBQD_DECLIST to PDMP;
grant select,insert,update,delete on BGCD_EDI.EDI_JBQD_HEAD_INFO to PDMP;
grant select on BGCD_EDI.SEQ_JBQD_HEAD_INFO to PDMP;