Re: webdb - how to drop a user

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 Thu Jan 13 2000 - 23:30:49 CET