Re: ORA-00942: How can access a table without pre-fixing the schema name

Another approach would be to create a PUBLIC synonym.

This allows the schema owner of the table to be irrelevant to any read-only users.

Example:
-- Run this as dbausr...
CREATE PUBLIC SYNONYM a FOR dbausr.a ;

Then try your select after connecting as a - no need to change the current schema.

Sincerely,

Philip Received on Thu Jul 14 2005 - 09:53:14 CDT