Hi, I'm in need of some SQL help regarding selection information from
an Oracle user account that only has "SELECT_CATALOG_ROLE' granted to
a schema within the same instance. I will not be able to get direct
access to the schema for some time. I will not be able to have "SELECT
ANY TABLE" granted or public synonymn.

The following is an example of what I need:

select * from <schema>.<table>; (This of course gives me an error
"ORA-00942: table or view does not exist")

I have access to views(dba_/v$/etc..)

What should I do?

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;

sergeant.rock (AT) gmail (DOT) com (Wario) wrote in message news:<c75b43bb.0409090528.39e5c2b0 (AT) posting (DOT) google.com>...
I'm trying to find a way, if possible, around that. The id I'm using
and can only use for right now is only granted the "SELECT CATALOG..."
For now, granting select/etc... will not be possible for security
reasons. It is in the works, paperwork/etc... sign off
procedures/etc... This will take months before the user account is
granted the correct priveledges. My question is if there is a way for
me to select the information I need with only having "SELECT
CATALOG..." granted to the user?

Well, that would be a "NO". This is the whole point behind security privileges.

kevin.m.mcdonald (AT) citigroup (DOT) com (Kevin) wrote in message news:<8aad2b51.0409091033.23ae6b79 (AT) posting (DOT) google.com>...

I agree with Romeo. There is not way to circumvent the system without
the correct privileges.