Re: Get all available tables?

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 17 Oct 1998 22:25:23 GMT
Message-ID: <3629e174.2194425@netnews.worldnet.att.net>

A list of tables that you _own_ can be had by selecting from a view named USER_TABLES. Another view named ALL_TABLES will return a list of tables to which you have access. Offhand, I'm not sure of the view that returns the rights that you have on those tables. I believe you need to look at USER_TAB_PRIVS, but I'm not certain without looking it up.

Jonathan

On Fri, 16 Oct 1998 14:56:42 -0400, "knez" <knez_at_ix.netcom.com> wrote:

>How can I get a list of all available tables and if possible rights to my
>Oracle 7.3.3 database.
>
>Thanks
>
Received on Sat Oct 17 1998 - 17:25:23 CDT