Re: Show user's tables & views
From: Carl Gohringer <cgohring_at_lucifer>
Date: Wed, 26 Oct 1994 09:45:24 GMT
Message-ID: <Cy9xro.6p1_at_nl.oracle.com>
Date: Wed, 26 Oct 1994 09:45:24 GMT
Message-ID: <Cy9xro.6p1_at_nl.oracle.com>
s11976_at_ctsc.hkbc.hk (PM Wong) writes:
: 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
Select object_type, object_name from dba_objects where owner='<username>';
-- regards, Carl +-----------------------------------------------------------------------------+ Carl Gohringer, European Development Centre Oracle Park, Bittams Lane, Chertsey, Surrey, England, KT16 9RG Internet : cgohring_at_uk.oracle.com +-----------------------------------------------------------------------------+Received on Wed Oct 26 1994 - 10:45:24 CET