How To Give Access Select On Oracle With SQL Developer

Now, The first you must be select query build synonym on database forex. If you want running query synonym and give access select data, you can do in user sys. Ok

[oracle@MARMER ~]$ sq

 SQL*Plus: Release 11.2.0.1.0 Production on Tue May 22 11:36:52 2018

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>select 'create synonym DEVELOPSOFTWARE.'||table_name||' for DBMARMER.'||table_name||';'

from dba_tables where owner='DBMARMER' order by TABLE_NAME;

SQL>grant select on DBMARMER.MMR_201204 to DEVELOPANALIS;

SQL>grant select on DBMARMER.MMR_201204 to DEVELOPSOFTWARE;

SQL>select * from dba_tables where owner='DBMARMER' order by TABLE_NAME;

SQL>create synonym DEVELOPSOFTWARE.MMR_201204 for DBMARMER.MMR_201204;

SQL>create synonym DEVELOPANALIS.MMR_201204 for DBMARMER.MMR_201204;

SQL>commit;