say king is our new user.

from scott grant select on emp to king.

from king do

create table emp as select * from scott.emp;

then from scott drop the table emp.

HTH