SELECTION CRITERIA

[Kevin]

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?

[Wario]

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;

[Kevin]

se***********@gmail.com (Wario) wrote in message news:<c7**************************@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;

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?

[Romeo Olympia]

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

ke**************@citigroup.com (Kevin) wrote in message news:<8a**************************@posting.google. com>...

se***********@gmail.com (Wario) wrote in message news:<c7**************************@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;

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?

[Wario]

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