GLOBAL TEMPORARY TABLE

conn hr/hr
create global temporary table emp(id number, name varchar2(22)) on commit preserve rows;

OR
create global  temporary table emp
on commit preserve rows as select * from employees;

insert into emp values(12,'dfsff');
select * from emp;

connect another hr session
select * from emp;
insert into emp values(10,'fsffdsfsd');
select * from emp;


grant select , insert on emp to scott;

conn scott/tiger
select * from emp;
insert into hr.emp values(22,'fsdf');
select * from emp;