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

最新推荐文章于 2024-07-16 14:52:32 发布

南来北往的客

最新推荐文章于 2024-07-16 14:52:32 发布

阅读量6.3w

点赞数 3

分类专栏： oracle

本文链接：https://blog.csdn.net/xlb744868186/article/details/50818011

版权

oracle 专栏收录该内容

9 篇文章 0 订阅

订阅专栏

//把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;