Re: Ways to list available tables?
From: Param <paramjit.sublok_at_citicorp.com>
Date: 1998/12/11
Message-ID: <3670A4D9.5523CD1B_at_citicorp.com>#1/1
Date: 1998/12/11
Message-ID: <3670A4D9.5523CD1B_at_citicorp.com>#1/1
Apart from the tables and other objects you own, try the following query to see what objects in the database you can access.
Select OWNER, TABLE_NAME, PRIVILEGE from ALL_TAB_PRIVS_RECD ;
Even though the column in the above query is TABLE_NAME, this will show you all the objects you can access. You may have the grant direct, or through a ROLE or PUBLIC role.
Paramjit Sublok Received on Fri Dec 11 1998 - 00:00:00 CET