private synonyms-request help

[jovery]

If you've granted access to the objects you can use something similar to the following

set heading off pages 0 feedback off
spool syn_create.sql
select 
  'CREATE SYNONYM '||table_name||
  ' FOR '||owner||'.'||table_name||';'
from all_tables
where owner = owner_of_objects;
spool off

Then run the resulting spool file.

HTH