grant select over a dblink.
417099Jun 5 2008 — edited Jul 3 2013Hi, we have two databases db817 (8.1.7) and db9i (9i)
db817 has user dbs and dblink db9ilink that connects to db9i
db9i has schema emp and table employees in it.
How can I grant select on emp.employees table of db9i to user dbs on db817? so that the user can select from employees table over dblink using the statement
select emp.employee from db9ilink
I did the following but got an error.
SQL> grant select on emp.employee@db9i to dbs;
grant select on emp.employee@db9i to dbs
*
ERROR at line 1:
ORA-02021: DDL operations are not allowed on a remote database