oracle查询创建用户,Oracle创建设置查询权限用户

--普通用户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;

文章来源: www.oschina.net，作者：wzb88，版权归原作者所有，如需转载，请联系作者。

原文链接：https://my.oschina.net/u/3954059/blog/3215644