oracle授予用户查询表权限

元怀

已于 2023-03-24 09:40:08 修改

阅读量5.3k

点赞数 1

分类专栏： Oracle 文章标签： oracle 数据库 Powered by 金山文档

于 2023-02-15 09:42:52 首次发布

本文链接：https://blog.csdn.net/zcj18537150970/article/details/129037620

版权

Oracle 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

create user tjjk_interface identified by tjjk_interface;
grant connect to  tjjk_interface;
grant create view to tjjk_interface;
grant select on pdss.check_pres_state_p to tjjk_interface;
grant select on pdss.check_pres_input to tjjk_interface;
grant select on inppdss.check_pres_state_p to tjjk_interface;
grant select on inppdss.check_pres_input to tjjk_interface;
grant select on  peaas.jill_userdef to tjjk_interface;

revoke select  on inppdss.check_pres_input from  tjjk_interface 
给tjjk_lj用户授权让tjjk_lj有授予别的用户查询视图的权限

grant select on inppdss.check_presc_result  to tjjk_lj with grant option;
grant select on  pdss.check_presc_result  to tjjk_lj with grant option;
grant select on PEAAS.presc  to tjjk_lj with grant option;
grant select on PEAAS.Presc_Detail  to tjjk_lj with grant option;