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>
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)Received on Tue Oct 25 1994 - 08:21:05 CET
[----------------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