Re: Ways to list available tables?

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 CST