Re: can you take a schema offline?
From: Shakespeare <whatsin_at_xs4all.nl>
Date: Thu, 12 Mar 2009 22:09:51 +0100
Message-ID: <49b97a27$0$184$e4fe514c_at_news.xs4all.nl>
ddf schreef:
> On Mar 12, 3:25 pm, rgvguplb <rgvgu..._at_gmail.com> wrote:
>
> 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
Date: Thu, 12 Mar 2009 22:09:51 +0100
Message-ID: <49b97a27$0$184$e4fe514c_at_news.xs4all.nl>
ddf schreef:
> On Mar 12, 3:25 pm, rgvguplb <rgvgu..._at_gmail.com> 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