Show user's tables & views

From: PM Wong <s11976_at_ctsc.hkbc.hk>
Date: 25 Oct 1994 15:21:05 +0800
Message-ID: <38ibl1$176n_at_ctsc.hkbc.hk>


Sorry for this trivial question. We have many old users which are to be dropped. It is good practice (I think) to know what tables (and/or views) they created so we can drop them before we revoke connect & resource from such users
But I don't know how to list all the tables and views created by all users of the tablespace.
Can someone tell me the command please

--

                    \\\//
                    (o o)

[----------------ooO-(_)-Ooo---------------] PM Wong (Computer Officer)
[User User User User User User User User Us] CTSC Hong Kong Baptist College
[ser User User User User User User User Use] 224 Waterloo Road, Kln. HONGKONG
[er User User User User User User User User] Voice: (852)3397425 Fax: 3397888
[------------------------------------------] Email: pm_at_ctsc.hkbc.hk
Received on Tue Oct 25 1994 - 08:21:05 CET

Original text of this message