How to Create a Read-Only User in Oracle
create user reader identified by reader123456;
grant connect,resource to reader;
grant select on AD_TEST to reader; # You can log in to the relevant user via a PL/SQL tool and grant the AD_TEST table to reader for access
create or replace synonym reader.AD_TEST for loanadmin.AD_TEST
grant select any table to reader;