Database Administration (MOSC)

MOSC Banner

ORA-00942 :table or view does not exist

edited Mar 14, 2012 3:14AM in Database Administration (MOSC) 9 commentsAnswered
Hi - Need help regarding user privileges.

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center