Re: Remove everything from a schema
Date: Fri, 28 Nov 2008 17:38:21 +0100
Message-ID: <49301e7d$0$22013$426a74cc@news.free.fr>
""Álvaro G. Vicario"" <alvaroNOSPAMTHANKS_at_demogracia.com> a écrit dans le message de news: ggojgo$af4$1_at_huron.algomas.org...
| Michel Cadot escribió:
<snip>|
| 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!
|
|
| --
| -- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
| -- Mi sitio sobre programación web: http://bits.demogracia.com
| -- Mi web de humor al baño María: http://www.demogracia.com
| --
Regards
Michel
Received on Fri Nov 28 2008 - 10:38:21 CST