Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews2.google.com!not-for-mail
From: sergeant.rock@gmail.com (Wario)
Newsgroups: comp.databases.oracle
Subject: Re: SELECTION CRITERIA
Date: 9 Sep 2004 06:28:11 -0700
Organization: http://groups.google.com
Lines: 12
Message-ID: <c75b43bb.0409090528.39e5c2b0@posting.google.com>
References: <8aad2b51.0409080654.beb84bd@posting.google.com>
NNTP-Posting-Host: 198.26.125.13
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1094736491 18296 127.0.0.1 (9 Sep 2004 13:28:11 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 9 Sep 2004 13:28:11 +0000 (UTC)
Xref: dp-news.maxwell.syr.edu comp.databases.oracle:28670

SELECT_CATALOG_ROLE grants you select privileges to data dictionary
tables.  The table you are trying to query does not fall into this
category.

In order to query a table in another schema, you must have privileges
to that tables.  privileges  can only be grant by user with DBA
rights.

i.e.

grant select on schema.table to scott;
grant update on schema.table to scott;