ORACLE user names and tables

From: Dianne M. Dalman <dalmandm_at_infonode.ingr.com>
Date: Tue, 14 Jan 1992 22:24:00 GMT
Message-ID: <1992Jan14.222400.8016_at_infonode.ingr.com>


I work with several different "flavors" of databases, and with the others, if you decide to delete a user and all of that user's associated data, it's quite easy , but in ORACLE, once you create a user name, it's there for life, it seems, unless someone can tell me otherwise.

It seems to me that this would be a VERY basic function, being able to undo what you do, or to delete a user and that user's tables with one command, but I HAVE NEVER FOUND IT!

Any help is DEEPLY appreciated, thanks!

*-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-*
| D. M. Dalman ! You realize, of course, |
| Sr. Software Stylist ! that this means war ! |
| b24a!dianne!dianne ! |
| 730-VH1-0 ! - Bugs Bunny - |
*-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-* Stolen classical quote of the day:
(A bit of non-tech to prevent atrophy of the other side of the brain)

This is the grave of Mike O'Day
Who died maintaining his right of way
His right was clear, his will was strong But he's just as dead as if he'd been wrong

  • Epitaph -

 There is so much good in the worst of us  and so much bad in the best of us
 that it hardly becomes any of us
 to talk about the rest of us

  • Annon -
Received on Tue Jan 14 1992 - 23:24:00 CET

Original text of this message