Re: Drop a user

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 27 Dec 2000 09:45:33 +0100
Message-ID: <92caun$6jqe2$2@ID-62141.news.dfncis.de>

answers embedded.

Hth,

Sybrand Bakker, Oracle DBA

"No Wonder" <manyingsek_at_yahoo.com> wrote in message news:92c2l4$n55$1_at_nnrp1.deja.com...
> Hi,
>
> What's the proper way to drop a DB user??
>

drop user <username> cascade

> When the user is dropped, do I have to manually delete all those
> tables/object of that user or it's done automatically by the server?
>

Guess! This is Oracle!

Please refer to the sql manual before posting such obvious questions. If you don't have it, it's online at http://technet.oracle.com

> Thanks,
> Johnny
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Wed Dec 27 2000 - 02:45:33 CST