grant all object to another user

If you really want to grant all objects to another user, you can get out of the 'grant' ,you can use database link.

The following example grants all objects belong to scott privileges to eagle


SQL> create user eagle identified by eagle;

User created.

SQL> grant create session to eagle;

Grant succeeded.

SQL> grant create database link to eagle;

Grant succeeded.

SQL> grant select any table to eagle;

Grant succeeded.

SQL> connect eagle/eagle@test
Connected.

SQL> create database link scott_test connect to scott identified by tiger using
'test';

Database link created.

SQL> select * from emp@scott_test;

       SAL        MGR      EMPNO
---------- ---------- ----------
        10       1342       1000
        10       1342       2000
        50       1342       2000
        60       1342       2000

SQL>