Home -> Usenet -> comp.databases.oracle -> Re: SELECTION CRITERIA

Re: SELECTION CRITERIA

From: Wario <sergeant.rock_at_gmail.com>
Date: 9 Sep 2004 06:28:11 -0700
Message-ID: <c75b43bb.0409090528.39e5c2b0_at_posting.google.com> 






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;
Received on Thu Sep 09 2004 - 15:28:11 CEST












Original text of this message