remote synonym to table at remote database doesn't work by 'desc ...'
Hi all:
It supposed to be a simple problem but it didn't work the way out! At local DB, I want 'report' user to be able to 'select' a table at remote database, not 'insert/delete', SELECT only -
At remote db, I created user 'readonly', grant it 'select' only privilege to "prod"."table_A" I wanted (note- table is owned by 'prod');
At local database, I create a db link point to 'readonly' user at remote database:
SQL> create public database link 'to_read_zip2.us.oracle.com' connect to readonly identified by its_password using 'service_name';
okay it was successfully created.
It supposed to be a simple problem but it didn't work the way out! At local DB, I want 'report' user to be able to 'select' a table at remote database, not 'insert/delete', SELECT only -
At remote db, I created user 'readonly', grant it 'select' only privilege to "prod"."table_A" I wanted (note- table is owned by 'prod');
At local database, I create a db link point to 'readonly' user at remote database:
SQL> create public database link 'to_read_zip2.us.oracle.com' connect to readonly identified by its_password using 'service_name';
okay it was successfully created.
0