Oracle创建设置查询权限用户

  • Z时代
  • 2024-01-10
  • 分类：综合

database

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

 

以上是 Oracle创建设置查询权限用户 的全部内容， 来源链接： utcz.com/z/532923.html

回到顶部