oracle 创建用户且只有查看权限

--创建用户

CREATE USER estate_user identified by agiledc51889;

--授予登录权限

grant connect to estate_user;

--授予查看某用户下某个表或视图权限

grant select on invest_agile_dev.VIEW_AREA_MAINTAIN_DATA to estate_user;

登录estate_user用户查询：select * from invest_agile_dev.VIEW_AREA_MAINTAIN_DATA;

--如果不想带原用户名称需要建立同义词
create synonym estate_user.VIEW_AREA_MAINTAIN_DATA for invest_agile_dev.VIEW_AREA_MAINTAIN_DATA;

登录estate_user用户查询：select * from   VIEW_AREA_MAINTAIN_DATA;

转载于:https://www.cnblogs.com/xsdf/p/11081271.html