Re: Drop user cascade eqvivalent in version 6 ?
From: Carl Gohringer <cgohring_at_lucifer>
Date: Thu, 2 Mar 1995 08:14:39 GMT
Message-ID: <D4t08F.41x_at_nl.oracle.com>
Date: Thu, 2 Mar 1995 08:14:39 GMT
Message-ID: <D4t08F.41x_at_nl.oracle.com>
je_at_nera.no (Jan-Olav Eide) writes:
: In ORACLE version 7.1 I can do a 'drop user cascade' command in
: order to remove a user and his database objects. How can I achieve
: the same functionality in version 6.0.34 ?
: --
: Jan-Olav Eide NERA AS, Box 27, N-1361 Billingstad, Norway
: email : je_at_nera.no
: "I don't believe in astrology, but then I'm a capricorn, and capricorns
: don't believe in astrology".
Unfortunatelly, you cannot in v6.
You can write a quick SQL script to drop all of the object that a user owns,
but the user definition will always remain in the dictionary.
You can prevent the user from using the account by revoking CONNECT privs.
-- regards, Carl +-----------------------------------------------------------------------------+ Carl Gohringer, Oracle European Development Centre, World Wide Education Oracle Park, Bittams Lane, Chertsey, Surrey, England, KT16 9RG Internet : cgohring_at_uk.oracle.com +-----------------------------------------------------------------------------+Received on Thu Mar 02 1995 - 09:14:39 CET