Re: Can't get rid of old users from sysuserlist

In article <1c4kfgINNi6e_at_morrow.stanford.edu>, ayub_at_krypton.Stanford.EDU (Ayub Butt) writes:
> Howdy
>
> I have a question about adding and deleting users into an Oracle Database.
>
> When I issue the command
>
> SQL> select * from sysuserlist;
>
> I get a list of about 20 users. This list include several users
> who no longer work here. I did issue REVOKE commands at the time
> of their departures but they still appear. Is it possible to get rid
> of those users from the Database?
>

I think in Oracle V6 you can't delete a old user from the sysuserlist. In Oracle7 you can do that with "drop user ... cascade".

kind regards

Mike

                                                                          ^
 Federal Ministry of Science and Research                               B | M
<-------------------------------------------------------------------------+---->
 Computer Center                                                        W | F
                                                                          |
 Klaus-Michael Hatzinger            mail: hatzinger_m_at_bmwf1f.bmwf.gv.at   |
 Bankgasse 1/209                   phone: 0043-222-53120/5188             |
 1014 Vienna, Austria                fax: 0043-222-53120/5155             V
================================================================================