Re: can you take a schema offline?

From: Shakespeare <>
Date: Thu, 12 Mar 2009 22:09:51 +0100
Message-ID: <49b97a27$0$184$>

ddf schreef:
> On Mar 12, 3:25 pm, rgvguplb <> wrote:
>> i have a couple of schemas i suspect are not used any longer but am
>> not sure.
>> is there a way i can make them inaccessible before actually dropping
>> them?
>> or do i basically have no option other than drop them?
>> I thought i might be able to take the tablespace where its objects are
>> in offline, but another schema shares that tablespace, so taking that
>> offline does not seem to be an option.
>> I am using 10gR2 on windows server 2003.
>> thanks

> Have you considered locking the user accounts and expiring the
> passwords? This wouldn't affect other users who may have access to
> those tables/views/etc but it would prevent any applications or
> individuals from connecting to the database with those accounts.
> Presuming no one 'screams' afterwards you could then drop the users.
> David Fitzjarrell

Too lazy/tired to look this up, but: can you drop users without dropping their schema objects?

Shakespeare Received on Thu Mar 12 2009 - 16:09:51 CDT

Original text of this message