Re: cleanup user's account

From: N Prabhakar <prabhs_at_po.pacific.net.sg>
Date: 1997/01/15
Message-ID: <5bijup$2v3@newton.pacific.net.sg>#1/1

xxsiu_at_gamma.uta.edu (Sunny Siu) wrote:
>How do I remove user's tables and associated objects and then finally drop
>the account? I know that I can easily drop an account using the Motif-based
>Svrmgr. How about cleaning associated objects?
>
>
>Thanks for your suggestions.
>
>--Sunny Siu
> University of Texas at Arlington
> siu_at_uta.edu
>

Hi,

Issue the following command to drop an user (including objects owned by him)

drop user <username> cascade;

Regards

N.Prabhakar Received on Wed Jan 15 1997 - 00:00:00 CST