Is there any way for an Oracle 8i user to get a list of tables to which he
has been granted Select? He doesn't own the tables and they don't list
selecting from tabs.

Try looking at ALL_TABLES.

HTH,
Brian

MCArch wrote:
--
================================================== =================

Brian Peasland
dba (AT) remove_spam (DOT) peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
the three"

MCArch wrote:

First, and most obviously, all tables in user_tables:

SELECT table_name
FROM user_tables

Secondly tables owned by other schemas to which you have been granted SELECT:

SELECT table_name
FROM user_tab_privs_recd
WHERE privilege = 'SELECT';

Then combine the two adding the owner:

SELECT 'MY SCHEMA' owner, table_name
FROM user_tables
UNION ALL
SELECT owner, table_name
FROM user_tab_privs_recd
WHERE privilege = 'SELECT';

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

Brian Peasland wrote:

Doesn't answer the question. Tables can show up in ALL_TABLES if you are granted
any privilege ... delete, insert, update, alter, reference, etc.: Not just
SELECT.

Any there are plenty of applications where you are allowed to insert but not
select.

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)