Re: ORACLE user names and tables

In article <1992Jan14.231353.3773_at_adobe.com>, mmwang_at_adobe.com (Michael Wang) writes:
>
> In article <1992Jan14.222400.8016_at_infonode.ingr.com> dalmandm_at_infonode.ingr.com (Dianne M. Dalman) writes:
> >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.
>
> You need to revoke all privileges from that user (connect, resource, dba),
> and make sure that user doesn't own any objects (tables, view, synonyms,
> indexes, etc.). If this is the case, then that user will be removed from
> the users list in the data dictionary.

I believe that is false, at least as of kernel version 6.0.33. Someone in Oracle Support told me this myth a number of years ago, but it isn't true, as far as I can tell. It is possible to get rid of users by doing a full export, then creating a new database and importing only the people you want, but that's a drag.

I have heard that there will be (is?) a DROP USER command in version 7. I'll be very grateful for it. Received on Tue Jan 21 1992 - 17:06:03 CET