--普通用户test,需要创建查询用户(cxtest),授权test的部分表或试图查询权限 -- 使用 SYSTEM创建用户 create user cxtest identified by cxtest default tabl
--普通用户test,需要创建查询用户(cxtest),授权test的部分表或试图查询权限
-- 使用 SYSTEM创建用户
create user cxtest
identified by cxtest
default tablespace USERS
temporary tablespace TEMP
profile DEFAULT;
grant create session to cxtest;
grant create synonym to cxtest;
---test用户赋权VJK_WBFK_CPXX、VJK_WBFK_GZB、VJK_WBFK_QMCCB给cxtest
grant select on VJK_WBFK_CPXX to cxtest;
grant select on VJK_WBFK_GZB to cxtest;
grant select on VJK_WBFK_QMCCB to cxtest;
--cxtest用户建同义词
create synonym VJK_WBFK_CPXX for test.VJK_WBFK_CPXX;
create synonym VJK_WBFK_GZB for test.VJK_WBFK_GZB;
create synonym VJK_WBFK_QMCCB for test.VJK_WBFK_QMCCB;
---cxtest用户下查询测试
select * From VJK_WBFK_CPXX;
select * From VJK_WBFK_GZB;
select * From VJK_WBFK_QMCCB;
--结束END--
本文标题: Oracle创建设置查询权限用户
本文链接: https://www.lsjlt.com/news/5271.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-16
2024-05-16
2024-05-16
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0