Re: sysusers deleted

Florian wrote:
> Hi,
>
> I accidentally deleted the SYSTEM.SYSUSERS table, I was clicking to
> delete a TEST table but I was too quick !!
>
> It's only a test server used for development, but reinstalling would
> still be quite a pain.
>
> So far everything is still working (login etc.), so I'm not sure what
> bad I did - but I figured that table has to be good for something?
>
> Can somebody tell me how to recreate that table? Or can I ignore that
> table and just keep on working?
>
>
> Thanks.

Two things.

1. The table is not Oracles
2. You and your team need to stop doing anything logged into Oracle as system other than manage the database. You had no business creating the table, no business working with the table, and no business deleting anything in that schema.

I'd suggest a SHUTDOWN IMMEDIATE until someone writes some security poicies and management agrees to fire the first person that violates them.

But to answer your immediate question ... rebuild from scratch to eliminate this and other land mines your team has built.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)