Re: sharing same tablespace , can't see table of other user?

The manual covers this type of stuff in detail in the admin part.

here is some dynamic sql
run as user1 and/or user2

---cut here---
set head off
set feed off
set pagesize 1000

spool grants_syns.sql

select 'grant select,insert,delete,update on '||table_name||' to PUBLIC;'
from user_tables
order by table_name
/

select 'create public synonym '||table_name||' for '||table_name||';'
from user_tables
order by table_name
/

spool off;
--cut here--

To run
SQLPLUS>@grants_syns.sql

Have Fun

--
Posted via http://dbforums.com