Re: How can I get a list of accessible tables

From: Hans Forbrich <forbrich_at_telusplanet.net>
Date: Thu, 31 Jul 2003 16:00:36 GMT
Message-ID: <3F293B80.9142457D@telusplanet.net>

MCArch wrote:

> 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.

Consider checking the documentation for the difference vetween the "DBA_", "ALL_" and "USER_" views such as ALL_TABLES There are a lot of views and they might be useful in the future.

For your amusement, also consider Googling for "Oracle Data Dictionary Poster" Received on Thu Jul 31 2003 - 11:00:36 CDT