Question

oracle里面dblink如何授权

在oracle里面创建了dblink,如何授权?查询,更新,删除
请简单明了的说明

Answer 1

Seems we can't grant select on dblink_name to user_account;
We are able to create public dblink so other users can make use of it.
公有dblink可以，私有不行，只能创建者使用。

CREATE [PUBLIC] DATABASE LINK <link_name>
USING '<service_name>';