My Oracle Support Banner

Accessing a Table with a Registered Schema in A Different User Schema Fails ORA-00942 (Doc ID 361577.1)

Last updated on AUGUST 29, 2010

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.3 to 10.2.0.2 - Release: 9.2 to 10.2
Information in this document applies to any platform.
XML DB

Checked for Relevance on 30-Aug-2010

Symptoms

Accessing a table, associated with a registered XML schema, that resides in another user's schema fails with error:

For example:

connect user1/user1;

grant select on categories to user2;

connect user2/user2;

CREATE OR REPLACE VIEW v_category (
CATEGORY, CATEGORY_NAME) AS SELECT
extractValue(value(cats),'category/@name')
FROM categories c;

ERROR at line 3:
ORA-00942: table or view does not exist 
 

Changes

The CATEGORIES table is a table that is associated with a registered schema.  The CATEGORIES table exists in the user1 schema.

User 2 has already been granted permissions to select on the CATEGORIES table.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
  Symptoms
  Changes
  Cause
  Solution

Platforms: 1-914CU;

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.