Re: deleting all database objects belonging to a user
Date: 1995/11/10
Message-ID: <4804bu$gki_at_news-s01.ny.us.ibm.net>#1/1
In <RSZ.95Nov10083604_at_aifbodette.aifb.uni-karlsruhe.de>, rsz_at_aifbodette.aifb.uni-karlsruhe.de (Roland Schaetzle) writes:
>Hallo,
>
>how can I delete (drop) all database objects belongig to a
>certain user in a simple way, i.e. I don't want to issue
>a 'drop xxx' command for ervery object (there are hundreds
>of those objects).
>
>Roland
>
>----------------------------------------------------------------------
>Roland Schaetzle email: schaetzle_at_aifb.uni-karlsruhe.de
>Institut AIFB Tel. : +49-721-608-4061
>Universitaet Karlsruhe
>---------- D-76128 Karlsruhe -- Englerstr.11 -- Raum 229 -----------
"DROP USER CASCADE" command drops user and his objets .
Sergul YUCEKOK
DBA
U&G Consulting Comp.
Received on Fri Nov 10 1995 - 00:00:00 CET