Re: How to delete a user and his table?
Date: Thu, 27 Sep 2001 09:58:55 -0400
Message-ID: <9ovb8p$k67$1_at_bcarh8ab.ca.nortel.com>
[Quoted] [Quoted] Just because your an Oracle DBA, it doesn't give you the right to have an Holier than thou attitude, the person was just asking for help!
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:9otj7d$eqqgq$1_at_ID-62141.news.dfncis.de...
>
> "ftp" <shyan_at_cse.cuhk.edu.hk> wrote in message
> news:9ot6t3$klf$1_at_eng-ser1.erg.cuhk.edu.hk...
> > drop user usernmae;
> > cannot delete the user if he/she has created tables.
> > How to drop the user and his/her tables?
> >
> > --
>
> drop user <username> cascade
>
> Are you planning to ask the syntax of *all* sql commands from this group
and
> never to study any manual?
>
> Regards,
>
> Sybrand Bakker, Senior Oracle DBA
>
>
>
Received on Thu Sep 27 2001 - 15:58:55 CEST