oracle建立只读用户
2018-05-18 10:17:12 点击：

oracle建立只读用户create user reader identified by reader123456;grant connect,resource to reader;grant select on AD_TES

oracle建立只读用户

create user reader identified by reader123456;
grant connect,resource to reader;

grant select on AD_TEST to reader; #可使用plsql工具进入我相关有的用户，授权表AD_TEST给reader访问
create or replace synonym reader.AD_TEST for loanadmin.AD_TEST
grant select any table to reader;