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>
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, CaliforniaReceived on Sat Oct 24 1992 - 02:55:26 CET