Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Weighting of tables involved in dblink

2025-01-17 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

User user_a above A has DBLINK,B_dblink that accesses B, and execute the following authorization on user user_a of library A, authorizing table1 of dblink to user_b of library A.

Grant select on table1@B_dblink to user_b

Error ORA-02021: DDL operation on remote database is not allowed

An accesses B through dblink, and the authority control is not on A, but on B, which user A uses to establish dblink, the permissions are all under this user of B.

The SR user on the MES server accesses the ERP through DBLINK. The user in ERP is erpsr, and the actual data is stored in the erpmes user in ERP.

1. Establish erpsr users in ERP

2. Erpsr can be authorized under the table under select erpmes under the erpmes user in ERP, and only select can be authorized.

3. Create synonyms in the following table of erpmes under the erpsr user of ERP.

4. Set up connect to of dblink,dblink and use erpsr under SR users in MES library.

-- Control permissions are controlled on the MES server, not on the ERP server. Step 4 below is to set up dblink to use erpsr users, but not erpmes users. Once you use erpmes users, then the SR users on the MES library actually use the privileges of erpmes users.

Do the following in ERP first

1.system users execute the following

Create user erpsr identified by 123456

Grant connect to erpsr

2.system users execute the following

Grant select on erpmes.table_name to erpsr

3.erpsr users execute the following

Create synonym table_name for erpmes.table_name

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report