Re: deleting all database objects belonging to a user

From: Sridhar Subramaniam <avion_at_ozemail.com.au>
Date: 1995/11/11
Message-ID: <30A59177.5919_at_ozemail.com.au>#1/1

Roland Schaetzle wrote:
>
> 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

---

Roland,
How about 'drop user xxx cascade' and then recreating the user.

-- 
Cheers

Sridhar Subramaniam
Avion Consulting Services
Sydney - Australia
Email : ssubrama_at_nibucorp.ccdn.otc.com.au / avion_at_ozemail.com.au

Disclaimer : All opinions are truly and just mine.

Received on Sat Nov 11 1995 - 00:00:00 CET