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

From: <sstephen_at_us.oracle.com>
Date: 24 Oct 92 01:55:26 GMT
Message-ID: <1992Oct23.175526.1_at_us.oracle.com>


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?
>
> Thanks
>
> Ayub

-- 

Revoke only takes away their privleges.  The only way to get rid of these users
in V6 would be to delete their names from the table, but this is also a good
way to corrupt your database.  In Oracle7, you can DROP USER or DROP USER ...
CASCADE, which avoids the previous problem.  If it really bothers you, you
could always re-write the SYSUSERLIST view to only include those users with
privleges, (or use your own view exclusively).

================================================================================
Scott Stephens				inet:	sstephen.us.oracle.com
Oracle WorldWide Support                Redwood City, California
Received on Sat Oct 24 1992 - 02:55:26 CET

Original text of this message