grant all object to another user

最新推荐文章于 2024-09-01 22:34:09 发布

原创最新推荐文章于 2024-09-01 22:34:09 发布 · 289 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库

oracle 专栏收录该内容

34 篇文章

订阅专栏

本文演示了如何使用SQL语句将权限授予其他用户，包括创建用户、授权会话、创建数据库链接，并通过数据库链接执行跨库查询。具体操作包括创建用户、授权创建会话、数据库链接以及执行跨库查询。

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>