ORA-00942 :table or view does not exist
There is a table owned by user APPS.I am trying to SELECT that table from user GLOBALREAD.
If I specify the SCHEMA_NAME.TABLE_NAME it is working fine.Without schema name it is giving following error
ORA-00942 :table or view does not exist
Examaple:-
SQL> select count(*) from APPS.mtl_system_items;
COUNT(*)
----------
14634503
SQL> select count(*) from mtl_system_items;
select count(*) from mtl_system_items
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> show user
USER is "GLOBALREAD"
SQL>
My question is is there any SYSTEM PRIVILEGE to access all tables owned by other user(In this case APPS)?Can GLOBALREAD user SELECT all tables with out specifing SCHEMA_NAME through a privilege?