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>
grant all object to another user
最新推荐文章于 2024-09-01 22:34:09 发布