Re: All tables

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 6 May 2005 06:29:25 -0700
Message-ID: <1115386165.184256.297990@f14g2000cwb.googlegroups.com>

The reasons the tables you queried "do not exist" is because the Oracle username you are using does not have privilege to select from those tables.

If you look in the Concepts manual and then the Oracle version# Reference Guide you will find information on the Oracle RDBMS data dictionary views. There are generally three versions of each view in the form of all_, dba_, and user_ some name such as all_tables, dba_tables, user_tables.

The ALL_ version shows you ALL tables that you have select privilege on The DBA_ version shows users with the DBA role or the SELECT ANY TABLE privilege information about all tables in the database The USER_ view shows the querying user only what they own

I believe you will find the following two articles of use:

How do I find information about a database object: table, index, constraint, view, etc... in Oracle ?
http://www.jlcomp.demon.co.uk/faq/object_info.html

How do I find out which users have the rights, or privileges, to access a given object ? http://www.jlcomp.demon.co.uk/faq/privileges.html

HTH -- Mark D Powell -- Received on Fri May 06 2005 - 08:29:25 CDT