Re: Remove everything from a schema

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Fri, 28 Nov 2008 17:38:21 +0100
Message-ID: <49301e7d$0$22013$>

""Álvaro G. Vicario"" <> a écrit dans le message de news: ggojgo$af4$
| Michel Cadot escribió:

| This is not a complement to Charles' solution but an alternative, isn't
| it? (Running "DROP USER schema CASCADE" would be an option but it
| implies contacting the DBA.)

Yes, it is an alternative.
The flaw of DROP USER is that it implies that you regrant each privilege you previously had after recreating the user.

| The production box will be using a bare Instant Client so I prefer not
| to rely on SQL*Plus commands but I get the idea. I've run the commands
| generated by your SELECT query and everything is happily gone. I can
| easily stuff it in a PHP script (or just run it manually).
| Thank you!
| --
| -- - Álvaro G. Vicario - Burgos, Spain
| -- Mi sitio sobre programación web:
| -- Mi web de humor al baño María:
| --

Michel Received on Fri Nov 28 2008 - 10:38:21 CST

Original text of this message