Re: webdb - how to drop a user

What do yo mean by small, we did some development and soon the module details exploded to 70.000 entries!
Upgrading this tables from 2.0 to 2.1 afterwards took us 25 hours! In the meantime I wrote a script to drop all the archived versions, took down the table to 10.000 entries.

TurkBear <johng_at_mm.com> schreef in berichtnieuws 387e51ac.259002185_at_204.181.81.99...
>
> Thanks, Leo - I always forget about those...since they are relatively
small
> tables I tend to get a little sloppy....
>
>
> "Leo Van Nieuwenhuyse" <leo.van.nieuwenhuyse_at_pandora.be> wrote:
>
> >DON'T FORGET to delete the entries in WWV_MODULES$ and
WWV_MODULE_DETAILS$
> >of the webdb-scheme,
> >Dropping the schema isn't enough!
> >TurkBear <johng_at_mm.com> schreef in berichtnieuws
> >387e3f21.254255570_at_204.181.81.99...
> >>
> >> Use
> >>
> >> Drop user user_name cascade;
> >> This will completely remove the user and all objects 'owned' by that
> >user...
> >>
> >> Ion Cionca <ion.cionca_at_epfl.ch> wrote:
> >>
> >> >Hi there
> >> >
> >> >Anybody knows how to delete a user who has been created with WebDB?
> >> >You might do this via a drop command but how do you verify that all
> >objects owned by that specific user are also removed?
> >> >
> >> >Can WebDB do it (and thus preserve the coherence of the database)?
> >> >
> >> >Thanx in advance for any hint
> >> > ion
> >>
> >>
> >>
> >> -----------== Posted via Newsfeeds.Com, Uncensored Usenet News
> >==----------
> >> http://www.newsfeeds.com The Largest Usenet Servers in the
World!
> >> ------== Over 73,000 Newsgroups - Including Dedicated Binaries
Servers
> >==-----
> >
>
>
>
> -----------== Posted via Newsfeeds.Com, Uncensored Usenet News
==----------
> http://www.newsfeeds.com The Largest Usenet Servers in the World!
> ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers
==----- Received on Sat Jan 22 2000 - 23:58:54 CET