Re: sysusers deleted

<fitzjarrell_at_cox.net> wrote in message
news:1105123320.342465.215170_at_f14g2000cwb.googlegroups.com...
>
> 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.
>
> SYSUSERS is not an object in either 9i or 10g, and I don't remember
> seeing it in 8i, either. It appears to be some 'homegrown' addition,
> possibly by someone more familiar with Sybase or SQL Server than
> Oracle. This may also be a table some application has installed (some
> like to use the SYSTEM tablespace for their objects, much to the
> chagrin and dismay of the DBA); you may want to check if any
> applications are failing due to its absence. It is not necessary for
> Oracle to function, as it is not part of the data dictionary.
>
> Ask around and see who may have created it. And possibly be a bit more
> selective with your mouse next time.
>
> David Fitzjarrell
>

sysusers is definitely an SQL Server system table.

Matthias Received on Fri Jan 07 2005 - 14:08:12 CST