Oracle创建用户，并赋于只读某几张表的权限

#进入数据库

康马ssl适用于网站、小程序/APP、API接口等需要进行数据传输应用场景，ssl证书未来市场广阔！成为成都创新互联公司的ssl证书销售渠道，可以享受市场价格4-6折优惠！如果有意向欢迎电话联系或者加微信：18980820575（备注：SSL证书合作）期待与您的合作！

su - oracle
sqlplus / as sysdba

#创建只读用户

create user kms identified by "123@456";
grant connect to kms;

#给表赋予权限

grant select on ecology.hrmresource to kms;
grant select on ecology.HrmDepartment to kms;
grant select on ecology.HrmSubCompany to kms;
grant select on ecology.hrmjobtitles to kms;

#创建同义词

grant create synonym to kms;
create or replace synonym kms.hrmresource for ecology.hrmresource;
create or replace synonym kms.HrmDepartment for ecology.HrmDepartment;
create or replace synonym kms.HrmSubCompany for ecology.HrmSubCompany;
create or replace synonym kms.hrmjobtitles for ecology.hrmjobtitles;

注意：如果不创建同义词，那么kms用户查询表时，必须使用ecology.table这类的写法，不能直接用table.

本文标题：Oracle创建用户，并赋于只读某几张表的权限
分享地址：http://bzwzjz.com/article/jjscdc.html