FINDING OUT THE TABLES CREATED BY A USER

The command shown below is used to determine the tables to which a user has access.
The tables created under the currently selected tablespace are displayed.

Example:

SELECT * FROM TAB;

Output:

TNAME                                             TABTYPE                             CLUSTERID

----------------------------------------------------------------------------------------------------

ACCT_MSTR                                     TABLE

ADDR_DTLS                                                TABLE

EMP_MSTR                                       TABLE

TRANS_DTLS                                   TABLE

TRANS_MSTR                                  TABLE

5 rows selected.