But the table is on a remote machine. There is a private synonym that uses a db_link connecting as the table owner of the remote table, so privs arent an issue:
Code:SQL> create user blah identified by blah; User created. SQL> grant CREATE SESSION, create synonym, create database link to blah; Grant succeeded. SQL> conn blah/blah Connected. SQL> create database link fc.world connect to ice identified by **** using 'icepw01.world'; Database link created. SQL> create synonym blah for [email protected]d; Synonym created. SQL> select count(*) from blah; COUNT(*) ---------- 76




Reply With Quote