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.