-- system/oracle
create user jacreate2 identified by 1234 ;
grant all privileges to jacreate2 ;
-- jacreate2/1234
create table test_syn(id int, name varchar(10));
insert into test_syn values (1,'lee');
select * from test_syn;
CREATE PUBLIC SYNONYM syn2 FOR test_syn;
select * from syn2 ;
GRANT SELECT ON jacreate2.syn2 TO system;
-- system/oracle
SELECT * FROM SYN2 ;