Private synonym not functioning - Insufficient privilege
connected as ada_user2
select * from orders;
ORA-1031 insufficient privileges But the select form ada_admin2.orders - brings data
SQL> select * from dba_synonyms where synonym_name='ORDERS'
OWNER SYNONYM_NAME
------------------------------ ------------------------------
TABLE_OWNER TABLE_NAME
------------------------------ ------------------------------
DB_LINK
--------------------------------------------------------------------------------
ADA_USER ORDERS
ADA_ADMIN ORDERS
ADA_USER2 ORDERS
ADA_ADMIN2 ORDERS
2 rows selected.
select * from orders;
ORA-1031 insufficient privileges But the select form ada_admin2.orders - brings data
SQL> select * from dba_synonyms where synonym_name='ORDERS'
OWNER SYNONYM_NAME
------------------------------ ------------------------------
TABLE_OWNER TABLE_NAME
------------------------------ ------------------------------
DB_LINK
--------------------------------------------------------------------------------
ADA_USER ORDERS
ADA_ADMIN ORDERS
ADA_USER2 ORDERS
ADA_ADMIN2 ORDERS
2 rows selected.
0