| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> comp.databases.oracle -> Re: SELECTION CRITERIA
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 - 08:28:11 CDT
 |
 |